Postgres Pro
Downloads
Home   >   mailing lists

Thread: alter database/user set problem

alter database/user set problem

From
"frank_lupo"
Date:
I use the PostgreSQL 7.3.1.

pippo=# ALTER user postgres SET "Autocommit" = "on"\g
ALTER USER
pippo=# ALTER user postgres SET "autocommit" = "off"\g
ALTER USER
pippo=# select usename,useconfig from pg_shadow\g
    usename    |           useconfig
---------------+-------------------------------
 postgres      | {Autocommit=on,autocommit=off}

Which autocommit it used from the user?

Bye !!
Frank Lupo (Wolf) !!

    /\_ _/\
    \ o o /
--ooo-----ooo---



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Fare shopping con EmailConto Risparmio è facile e conveniente: con un solo click sconti tutti i tuoi acquisti!
Provalo adesso.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=839&d=28-1

Re: alter database/user set problem

From
Tom Lane
Date:
"=?utf-8?Q?frank=5Flupo?=" <frank_lupo@email.it> writes:
> pippo=# ALTER user postgres SET "Autocommit" = "on"\g
> ALTER USER
> pippo=# ALTER user postgres SET "autocommit" = "off"\g
> ALTER USER
> pippo=# select usename,useconfig from pg_shadow\g
>     usename    |           useconfig
> ---------------+-------------------------------
>  postgres      | {Autocommit=on,autocommit=off}

This is a bug --- it should be doing case-insensitive comparisons to
detect duplicate variable names.  Will fix for 7.3.2.

> Which autocommit it used from the user?

Probably the last one stored...

            regards, tom lane