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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
