Re: [ADMIN] Re: [INTERFACES] Ghost insert

From: Enrique Rodriguez Lazaro <enrique(at)xpress(dot)es>
To: PSQL ADMIN <pgsql-admin(at)postgreSQL(dot)org>
Subject: Re: [ADMIN] Re: [INTERFACES] Ghost insert
Date: 1999-12-23 18:40:20
Message-ID: 38626C94.FE3D1176@xpress.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Tom Lane wrote:
>
> Enrique Rodriguez Lazaro <enrique(at)xpress(dot)es> writes:
> >>>> I can't do a simple 'insert' from libpq.
>
> Come to think of it, the uncommitted-transaction problem could also
> exist on the query side (the apache client). If that client is
> running in SERIALIZABLE transaction mode, it won't see the effect
> of an insert transaction started after its own current transaction.
> So you might need to do a commit/begin cycle on that side too.
>
> regards, tom lane
>
> ************

Thank you very much. COMMIT was the solution.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Robert Rothe 1999-12-23 20:51:28 Always get TranBlock notice using 'c'
Previous Message D'Arcy J.M. Cain 1999-12-23 17:00:49 Re: [INTERFACES] Ghost insert