notice on transaction abort?
| От | Kovacs Zoltan Sandor |
|---|---|
| Тема | notice on transaction abort? |
| Дата | |
| Msg-id | Pine.LNX.4.05.10101182218300.3812-100000@pc10.radnoti-szeged.sulinet.hu обсуждение исходный текст |
| Ответы |
Re: notice on transaction abort?
|
| Список | pgsql-sql |
I realized that an error will abort a transaction all the time. Unfortunately I usually send millions of rows of INSERTs in a transaction and if there is some error in the middle of the code I got the message if I try to INSERT a new row: NOTICE: current transaction is aborted, queries ignored until end of transaction block *ABORT STATE* OK, this is a nice feature. But I sometimes make mistakes at the end of the transaction and I got no such message. There is no easy way to find out if there was an aborted transaction or not. Can I consider this as a bug? Probably not, but I suggest dropping something similar immediately after aborting. Your opinion, please? :-) Regards, Zoltan
В списке pgsql-sql по дате отправления: