yep. looks like it was the library. thanks, Eugene --- Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> wrote: > Tom Lane wrote: > > Dr NoName <spamacct11@xxxxxxxxx> writes: > > > ... My question is, would > > > postgresql ps string show COMMIT at the end of > > > INSERT/UPDATE even if explicit transactions are > not > > > used? > > > > No. > > My guess is that his interface library is doing it. > > -- > Bruce Momjian | > http://candle.pha.pa.us > pgman@xxxxxxxxxxxxxxxx | (610) > 359-1001 > + If your life is a hard drive, | 13 Roberts > Road > + Christ can be your backup. | Newtown > Square, Pennsylvania 19073 > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will > ignore your desire to > choose an index scan if your joining column's > datatypes do not > match > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings