why are my SELECTs in transaction? - Mailing list pgsql-general

From Travis Hume
Subject why are my SELECTs in transaction?
Date
Msg-id 3EF0A927.7080000@tenzing.com
Whole thread Raw
Responses Re: why are my SELECTs in transaction?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Inflight=# select usename from pg_user;
 usename
---------
 fc
 luser
 ping
(3 rows)

Inflight=# select * from badtable;
ERROR:  Relation "badtable" does not exist
Inflight=# select usename from pg_user;
ERROR:  current transaction is aborted, queries ignored until end of
transaction block


So at this point all selects are screwed unless I issue a ROLLBACK;
Why?  Is there a way for SELECTs (or all SQL) statement that fail to NOT
have this behaviour?


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: PostgreSQL alternative to "Oracle Real Application
Next
From: Jonathan Bartlett
Date:
Subject: Re: PostgreSQL alternative to "Oracle Real Application