Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Ghost insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Enrique Rodriguez Lazaro <enrique(at)xpress(dot)es>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Ghost insert
Date: 1999-12-23 15:15:55
Message-ID: 6385.945962155@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Enrique Rodriguez Lazaro <enrique(at)xpress(dot)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

In response to

  • Ghost insert at 1999-12-23 09:03:12 from Enrique Rodriguez Lazaro

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-12-23 15:36:15
Subject: Re: [INTERFACES] Ghost insert
Previous:From: D'Arcy J.M. CainDate: 1999-12-23 14:41:30
Subject: Re: [INTERFACES] Ghost insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group