EXECUTION_LOCK variable

Default for PgPubSubOptions.executionLock — off. Enable with PG_PUBSUB_EXECUTION_LOCK.

When on, a message is de-duplicated by CONTENT rather than by listener: a marker row is written for each handled payload, and an identical payload arriving again within UNIQUE_LOCK_TTL is skipped. That protects against duplicate publication, but it also means two legitimately identical notifications collapse into one — which is a correctness problem if your payloads are not unique.

Signature:

EXECUTION_LOCK: boolean

Read this page as plain markdown — no HTML, no navigation. For pasting into an LLM, or for an agent to fetch.