why are my SELECTs in transaction?

Поиск
Список
Период
Сортировка
От Travis Hume
Тема why are my SELECTs in transaction?
Дата
Msg-id 3EF0A927.7080000@tenzing.com
обсуждение исходный текст
Ответы Re: why are my SELECTs in transaction?
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: PostgreSQL alternative to "Oracle Real Application
Следующее
От: Jonathan Bartlett
Дата:
Сообщение: Re: PostgreSQL alternative to "Oracle Real Application