Transaction Aborted
От | Edwin S. Ramirez |
---|---|
Тема | Transaction Aborted |
Дата | |
Msg-id | 42194FF0.2030100@idconcepts.org обсуждение исходный текст |
Ответы |
Re: Transaction Aborted
|
Список | pgsql-hackers |
Hello, This may sound familiar since there was a discussion before... I created an importing tool which allows users to load data into their tables using a graphical interface. The import operations occur within a transaction so that the user gets a chance to change their mind. After the import is finished the user is presented with a choice to "abort", "commit" or interact with the database. Interacting with the database allows the user to submit queries to verify the data load. Everything works great except that if the user makes any typos the entire transaction is aborted, requiring the import process to be done again. I was under the impression that the nested transaction feature would make this go away. I played a little with it and it seems that the entire transaction is aborted even if a checkpoint is created. Could someone please help me with this? -Thanks, Edwin S. Ramirez
В списке pgsql-hackers по дате отправления: