On 17 Aug 2004, Greg Stark wrote: > With Postgres I effectively have to work in autocommit mode. Starting over > from scratch every time I make a typo is infeasible. It feels like trying to > type in a C program using "cat". I've done it before but it's not something I > want to repeat often.
I agree. I would like to not use autocommit but I do way to many syntax errors for it to be practical in pg. Autocommit for me is just a hack to get around the above "limitation". > In an ideal world I would actually have suggested all drivers would want to > work this way. For interactive use I'd like simple errors like syntax error to not abort a transaction. For other uses it's good that it aborts. -- /Dennis Björklund ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])