Postgres Pro
Downloads
Home   >   mailing lists

Re: alter database/user set problem - Mailing list pgsql-general

From Tom Lane
Subject Re: alter database/user set problem
Date
Msg-id 13626.1043770377@sss.pgh.pa.us
Whole thread Raw
In response to alter database/user set problem  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
Tree view 
"=?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

pgsql-general by date:

Previous
From: Ryan VanderBijl
Date:
Subject: serialization errors
Next
From: Stephan Szabo
Date:
Subject: Re: Ref to last INSERT on a table without OIDs?