Re: alter database/user set problem

"=?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