"Jason" <jason@op480.com> writes:
> The odd thing is, when I do these queries they do not fail, yet they do not
> insert.
Perhaps the php code is running inside a transaction block? If so, the
added rows won't be visible to other connections until (and unless) the
transaction is committed. The rows *would* be visible to subsequent
commands issued by that same php connection, though --- have you tried
checking that way?
> It still increases the serial primary key ("id")
This is consistent with my theory. Sequence-object bumps are
immediately visible regardless of transaction boundaries.
regards, tom lane