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/



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to