psql feature thought - Mailing list pgsql-hackers

From Joshua D. Drake
Subject psql feature thought
Date
Msg-id 44693FBD.4090005@commandprompt.com
Whole thread Raw
Responses Re: psql feature thought
Re: psql feature thought
List pgsql-hackers
Hello,

I was dinking around wand came across something that may (or may not be 
useful).

What if single line statements that were seperated by ; within psql were 
implicitly within a transaction?

E.g;

postgres=# select * from foo; update foo set bar = 'baz'; delete from bing;

Would be a single transaction ? The begin/commit would be implicit.

Joshua D. Drake



-- 
           === The PostgreSQL Company: Command Prompt, Inc. ===     Sales/Support: +1.503.667.4564 || 24x7/Emergency:
+1.800.492.2240    Providing the most comprehensive  PostgreSQL solutions since 1997
http://www.commandprompt.com/




pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: audit table containing Select statements submitted
Next
From: Tom Lane
Date:
Subject: Re: psql feature thought