Re: COMMIT in ps output

yep. looks like it was the library.

thanks,

Eugene


--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:

> Tom Lane wrote:
> > Dr NoName <spamacct11@yahoo.com> 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@candle.pha.pa.us               |  (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