On Thu, 29 Jul 1999, Brian Curnow wrote:
>
> 1) An INSERT statement that fails before completion can still use up a
> sequence #
I'm thinking this is what happened. It seems to me postgresql would need
to read the sequence value generator before it could perform the insert.
Once a sequence gen
Hello,
I have a table with:
A DEFAULT sequence number
A rule that causes a NOTIFY on insert
A spawned process that does one INSERT on the table per spawning.
Two processes LISTENing for INSERTs, one of which does a single UPDATE
after processing.
Last night I had four consecutive INSERTs on the