On 03/01/2012 11:37 AM, Carlos Mennens wrote:
I changed to the suggested database which is owned by 'Carlos' and did
as instructed. Everything worked fine. Thank you!

In your previous post my guess is this:

iamunix=# \c postgres

was really meant to be:

iamunix=# \c - postgres

The first changes to database postgres as current user, the second
changes the user while remaining on the current database.


On Thu, Mar 1, 2012 at 11:23 AM, Carlos Mennens
<carlos.menn...@gmail.com>  wrote:
I did do a Google search for "PostgreSQL 9.1 change ownership
recursively" but either couldn't find what I was looking for or
missed it.

On Thu, Mar 1, 2012 at 1:36 PM, Adrian Klaver<adrian.kla...@gmail.com>  wrote:
For future reference including the Postgres version would be
helpful. This area ownership/grants/etc has undergone a lot of changes over
the various versions.

I specified above I was using 9.1 PostgreSQL.

Oops, my mistake, I never got to the PS:(


--
Adrian Klaver
adrian.kla...@gmail.com

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to