[GENERAL] Transactions

2006-03-17 Thread Kevin Brown
I've been creating a databased application with PostgreSQL for a while now and have loved it, though we just recently stumbled on an interesting bug. I have a particular dialog which can do all kinds of incredibly complicated things to the database. Of course I didn't want to have to write the

Re: [GENERAL] Transactions

2006-03-17 Thread Kevin Brown
On Saturday 18 March 2006 00:19, Tom Lane wrote: > Kevin Brown <[EMAIL PROTECTED]> writes: > > So when the dialog opens, it executes a BEGIN, and then based on whether > > they clicked ok or cancel on the dialog, it'd COMMIT or ROLLBACK. This > > worked fine for me

Re: [GENERAL] Transactions

2006-03-18 Thread Kevin Brown
On Saturday 18 March 2006 12:31, Florian G. Pflug wrote: > Kevin Brown wrote: > > I've been creating a databased application with PostgreSQL for a while > > now and have loved it, though we just recently stumbled on an interesting > > bug. > > > > I have a pa

Re: [GENERAL] Transactions

2006-03-18 Thread Kevin Brown
On Saturday 18 March 2006 12:58, Florian G. Pflug wrote: > Kevin Brown wrote: > > So what you're saying is that my commits and rollbacks should be async, > > correct? > > No, you should always use _async(), and never, ever use query() or exec() > in a multi-thre