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