Enrique Rodriguez Lazaro <enrique@xpress.es> writes:
> I can't do a simple 'insert' from libpq.
Perhaps you did a "BEGIN" and haven't yet done a "COMMIT"?
The result of your insert (or any other data update command)
won't be visible to other clients until and unless you commit it.
However, if you haven't issued a BEGIN then the default behavior
is to auto-commit after every successful command, so I'm not sure
that's the right answer...
regards, tom lane