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

From Enrique Rodriguez Lazaro
Subject Re: [ADMIN] Re: [INTERFACES] Ghost insert
Date
Msg-id 38626C94.FE3D1176@xpress.es
Whole thread Raw
In response to Re: [INTERFACES] Ghost insert  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-interfaces
Tom Lane wrote:
> 
> Enrique Rodriguez Lazaro <enrique@xpress.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.


pgsql-interfaces by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [INTERFACES] Ghost insert
Next
From: Robert Rothe
Date:
Subject: Always get TranBlock notice using 'c'