Received: from maria.xpress.es (bestia.xpress.es [194.224.86.3]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA13716; Thu, 23 Dec 1999 13:38:51 -0500 (EST) (envelope-from enrique@xpress.es) Received: from xpress.es (idefix.xpress.es [194.224.86.59]) by maria.xpress.es (8.8.8/8.8.8) with ESMTP id TAA19949; Thu, 23 Dec 1999 19:33:32 GMT Sender: enrique@bestia.xpress.es Message-ID: <38626C94.FE3D1176@xpress.es> Date: Thu, 23 Dec 1999 19:40:20 +0100 From: Enrique Rodriguez Lazaro X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i586) X-Accept-Language: en MIME-Version: 1.0 To: PSQL ADMIN Subject: Re: [ADMIN] Re: [INTERFACES] Ghost insert References: <38624AD0.D6AD053@xpress.es> <7011.945970756@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > > Enrique Rodriguez Lazaro 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.