<html><DIV>Hi:</DIV>
<DIV> </DIV>
<DIV>It seems to me that postgresql db's default set for commit is "on". I would like to set it to "off". How could I do that?</DIV>
<DIV> </DIV>
<DIV>TIA.</DIV>
<DIV>----------</DIV>
<DIV>Here is what I got when testing:</DIV>
<DIV> </DIV>
<DIV><FONT size=2>
<P>webstore=> create table t1 (col1 varchar(10));</P>
<P>CREATE</P>
<P>webstore=> insert into t1 (col1) values ('test123');</P>
<P>INSERT 1006769 1</P>
<P>webstore=> select * from t1; </P>
<P>col1 </P>
<P>---------</P>
<P>test123</P>
<P>(1 row)</P>
<P>webstore=> rollback;</P>
<P>NOTICE: ROLLBACK: no transaction in progress</P>
<P>ROLLBACK</P>
<P>webstore=> select * from t1;</P>
<P>col1 </P>
<P>---------</P>
<P>test123</P>
<P>(1 row)</P></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV><br clear=all><hr>Get your FREE download of MSN Explorer at <a href="http://explorer.msn.com">http://explorer.msn.com</a><br></p></html>