Re: ECPG bug in --help

Michael Meskes wrote:
> On Fri, Jan 04, 2002 at 04:02:14PM +0000, Lee Kindness wrote:
> > Michael, hope you've had a good Christmas & all the best for the New
> > Year...
>
> Sure. Thanks.
>
> > When you run 'ecpg --help' you get the following:
> >
> >       -t   turn on autocommit of transactions
> >
> > amongst the other options... Shouldn't this be OFF as per the
> > documentation?
>
> No, this is correct. However, there are some problems in the wording.
> autocommit means "use the default transactions from PGSQL" while
> auto-transaction mode means to "start a new transaction after each commit".
> The latter is the way Oracle handles this, you just have to issue commits
> but no begin trans. The first of course is the very same as working with
> pgsql.
>
> This needs some clearer wording urgently. I haven't checked Bruce changes so
> far.

I merely changed ecpg.sgml to match the --help message, which is (I
thought) correct.  The Ingres wording "autocommit" means the standard we
have in pgsql, that is a single query is assumed to be a single
transaction and BEGIN must be used to create multi-query transactions.

OK, I see your wording now.  ref/ecpg.sgml was originally correct too,
but the confusion was that --help talked about autocommit on while
ecpg.sgml talked about auto-transaction off.  I have updated the entry
to be:

     <varlistentry>
      <term>-t</term>
      <listitem>
       <para>
        Turn on auto-commit of transactions.
       </para>
      </listitem>
     </varlistentry>

This now matches --help.  Please let me know how you like it.  Good
catch.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026