Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA59027
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 23 Dec 1999 10:17:03 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA06388;
	Thu, 23 Dec 1999 10:15:55 -0500 (EST)
To: Enrique Rodriguez Lazaro <enrique@xpress.es>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Ghost insert 
In-reply-to: <3861E550.8ED9448@xpress.es> 
References: <3861E550.8ED9448@xpress.es>
Comments: In-reply-to Enrique Rodriguez Lazaro <enrique@xpress.es>
	message dated "Thu, 23 Dec 1999 10:03:12 +0100"
Date: Thu, 23 Dec 1999 10:15:55 -0500
Message-ID: <6385.945962155@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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