Received: from corvette.mascari.com (dhcp26131045.columbus.rr.com [24.26.131.45]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA25084; Sat, 18 Dec 1999 21:00:34 -0500 (EST) (envelope-from mascarm@mascari.com) Received: from mascari.com (ferrari.mascari.com [192.168.2.1]) by corvette.mascari.com (8.8.7/8.8.7) with ESMTP id UAA11094; Sat, 18 Dec 1999 20:58:31 -0500 Message-ID: <385C3BE0.D307E8B5@mascari.com> Date: Sat, 18 Dec 1999 20:58:56 -0500 From: Mike Mascari Organization: Mascari Development Inc X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: Alex Guryanow CC: pgsql-general@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END References: <385C1F8E.2CC771A7@nlr.ru> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Alex Guryanow wrote: > > Hi, > > I'm use Postgres-6.5.1 on Linux. My database contains two tables and two > indices. I wrote simple program on C that > - begins transaction: BEGIN WORK > - inserts many (10-500) rows in the first table > - commits the transaction: COMMIT > - begins transaction: BEGIN WORK > - inserts many (1-50) rows in the second table > - commits the transaction: COMMIT > > During execution of this program I receive very often the following > message: > > NOTICE: (transaction aborted): queries ignored until > END > > that repeated many times. > > What means this message? And why this happens? > > Best regards, > Alex That message appears when an error has occurred in a transaction. It means that no other SQL statements will be processed until the transaction has ended and a new one has begun. For example: CREATE TABLE example(key text); => begin; BEGIN => insert into example values ('foo'); INSERT 181193 1 => insert into example values ('bar', 20); ERROR: INSERT has more expressions than target columns => insert into example values ('bar'); NOTICE: (transaction aborted): queries ignored until END *ABORT STATE* => commit; END => select * from example; key --- (0 rows) It sounds as if some of your INSERT statements are not being properly executed, often due to embedded single quotes in text strings, lack of NULL values for missing datetime values, or some other such syntax error. You should be able to use PQresultStatus() and PQerrorMessage() to determine precisely the error which is causing the transaction to abort. Hope that helps, Mike Mascari