Does error within transaction imply restarting it?

Поиск
Список
Период
Сортировка
От Haroldo Stenger
Тема Does error within transaction imply restarting it?
Дата
Msg-id 38F75B95.BA1F8319@adinet.com.uy
обсуждение исходный текст
Список pgsql-general
Hello dear fellows,

I need to get insight about this:

1. A transaction begins
2. LOCK TABLE XYZ; is issued.
3. Since table XYZ doesn't exist, the backend gives error.
4. A CREATE TABLE XYZ(field char); is issued.
5. The backend says that it is in abort state, and that all queries will
be ignored until commit, or end of transaction.

Is this behaviour unavoidable? I mean, can the backend ignore the fact
that I issued a command that yielded an error, and continue accepting
SQL statements within the transaction? Is there a hack or something?

Thank you very much in advance.

Cheers,
Haroldo.

В списке pgsql-general по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: database file size bloat
Следующее
От: Thomas Reinke
Дата:
Сообщение: Re: Postgresqlism & Vacuum?