alter database/user set problem

Lists: pgsql-general
From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: alter database/user set problem
Date: 2003-01-28 12:26:29
Message-ID: H9FBW5$F54F7ADED8EABA16880DD578A4184387@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frank_lupo <frank_lupo(at)email(dot)it>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: alter database/user set problem
Date: 2003-01-28 16:12:57
Message-ID: 13626.1043770377@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

"=?utf-8?Q?frank=5Flupo?=" <frank_lupo(at)email(dot)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