Re: [INTERFACES] Ghost insert - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Ghost insert
Date
Msg-id 6385.945962155@sss.pgh.pa.us
Whole thread Raw
In response to Ghost insert  (Enrique Rodriguez Lazaro <enrique@xpress.es>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [INTERFACES] Ghost insert
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Ghost insert