From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: remove variables |
Date: | 2013-01-06 17:31:26 |
Message-ID: | 1357493486.336.3.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, 2013-01-04 at 16:18 +0100, Bartosz Dmytrak wrote:
> Hi,
> one of my dbs has the following settings:
> ALTER ROLE hibuser IN DATABASE kpi
> SET default_transaction_read_only = 'off';
> ALTER DATABASE kpi
> SET search_path = "$user", pg_temp;
>
> I would like to remove hibuser settings using pgAdmin so I navigate to db
> node in explorer tree, right click on db node -> properties -> variables
> tab and remove unneeded setting, proper one is chosen - I made double check
> :) . SQL generated by pgAdmin looks like this one:
>
> ALTER ROLE "$user", pg_temp IN DATABASE kpi
> RESET "$user", pg_temp;
>
> but should look like this:
> ALTER ROLE "hibuser" IN DATABASE kpi RESET default_transaction_read_only;
>
> it looks like potential bug in this functionality
>
It is a bug. Thanks to you, this is a fixed bug now.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2013-01-06 17:33:00 | Re: Can't access URLs in documentation |
Previous Message | Robert Klaus | 2013-01-06 17:27:13 | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |