Re: upgrade 1.2.21 -> 1.3.0 svn revision 3807 == Almost

[Chris Travers <..hidden..>]

sorry that query is wrong.  Use this one
SELECT admin__add_user_to_role('[username]', rolname)
FROM pg_roles
WHERE rolname like 'lsmb_' || current_database() || '__%';

On Sat, Oct 8, 2011 at 11:59 AM, Chris Travers <..hidden..> wrote:
> And you will need to then to add your user to roles.  If you want to
> give your role full perms:
>
> SELECT admin__add_user_to_role('[username]', rolname)
> FROM pg_roles
> WHERE rolname like 'lsmb_' || current_database();
>