NOTICE: (transaction aborted): queries ignored until END

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: NOTICE: (transaction aborted): queries ignored until END
Date: 1999-12-18 23:58:06
Message-ID: 385C1F8E.2CC771A7@nlr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Tassell 1999-12-19 00:05:44 Re: [GENERAL] Postgres install problem
Previous Message Mike Beller 1999-12-18 21:51:29 copy command -- foiled by pg_atoi

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Mascari 1999-12-19 01:58:56 Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END
Previous Message angelko 1999-12-18 23:00:18 [Q] Merging two queries?