Tom Lane wrote: > The patch disallows LISTEN/NOTIFY in a prepared transaction, and there > is also a side effect on whether a transaction can see entries in > pg_listener for its own uncommitted LISTEN commands.
I wonder if it would've been easier to make NOTIFY use SnapshotDirty to examine pg_listener, thus causing it to see the uncommitted rows. Would that work at all? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches