Re: COMMIT in ps output

From: Dr NoName <spamacct11(at)yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dr NoName <spamacct11(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT in ps output
Date: 2005-08-17 22:43:33
Message-ID: 20050817224333.42714.qmail@web31514.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

yep. looks like it was the library.

thanks,

Eugene

--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:

> Tom Lane wrote:
> > Dr NoName <spamacct11(at)yahoo(dot)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(at)candle(dot)pha(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oluwatope Akinniyi 2005-08-17 23:18:14 Are these normal?
Previous Message Jim C. Nasby 2005-08-17 22:40:34 Re: Field order