Re: Multiple Xids in PGPROC?
От | Rod Taylor |
---|---|
Тема | Re: Multiple Xids in PGPROC? |
Дата | |
Msg-id | 1083732074.54823.15.camel@jester обсуждение исходный текст |
Ответ на | Re: Multiple Xids in PGPROC? (Christopher Kings-Lynne <chriskl@familyhealth.com.au>) |
Список | pgsql-hackers |
On Wed, 2004-05-05 at 00:45, Christopher Kings-Lynne wrote: > > Yup.. And some of us intend on wrapping every single statement in a > > subtransaction so we can rollback on an error without aborting the main > > transaction. > > Point there being "main transaction". What i'm saying is that the vast > majority of your "transactions" will be single statements. eg. single > selects, single updates, etc. Actually, they're not. A vast majority of my transactions are over 5 statements -- each of which is eagerly anticipating being wrapped in a subtransaction. > > In fact, I would be surprised if tools like psql went very long without > > doing the same thing so users can recover from spelling mistakes. > > If the user does an explicit BEGIN, then perhaps we might, but how often > does the user do an explicit BEGIN? What user? Users aren't allowed in production. Strictly code.
В списке pgsql-hackers по дате отправления: