X-Original-To: pgsql-interfaces@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DA55A476657
	for <pgsql-interfaces@postgresql.org>;
	Tue,  4 Mar 2003 15:30:23 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 06288-10 for <pgsql-interfaces@postgresql.org>;
	Tue,  4 Mar 2003 15:30:20 -0500 (EST)
Received: from localhost.localdomain (167.95.252.64.snet.net [64.252.95.167])
	by postgresql.org (Postfix) with ESMTP id 4A230476B0A
	for <pgsql-interfaces@postgresql.org>;
	Tue,  4 Mar 2003 15:10:54 -0500 (EST)
Received: (from wweng@localhost)
	by localhost.localdomain (8.11.6/8.11.6) id h24KBes08545
	for pgsql-interfaces@postgresql.org; Tue, 4 Mar 2003 15:11:40 -0500
X-Authentication-Warning: localhost.localdomain: wweng set sender to
	wweng@kencast.com using -f
Date: Tue, 4 Mar 2003 15:11:40 -0500
From: Wei Weng <wweng@kencast.com>
To: pgsql-interfaces@postgresql.org
Subject: Is this a bug?
Message-ID: <20030304151140.A8536@example.com>
Reply-To: Wei Weng <wweng@kencast.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5.1i
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200303/11
X-Sequence-Number: 3760

This is roughly the procedure I took:

1: create a brand name database.

2: create table(s) with psql utility.

3: connect to it using libpq, and do an insert at the very first run.

And the backend returns the infamous "transaction abored, query ignored"
message. However all the following inserts/deletes/updates worked.

But if I do this instead:

3: connect to it using libpq, and do a select call then an insert.

It then went through successfully. (Both the selection and insertion).

Was this a known issue on 7.2 or is it just something on my end I did wrong?


Thanks

Wei