Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 67630101438B
	for <pgsql-sql@postgresql.org>; Thu,  1 Mar 2012 15:37:34 -0400 (AST)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <carlos.mennens@gmail.com>) id 1S3Bog-0007kd-EV
	for pgsql-sql@postgresql.org; Thu, 01 Mar 2012 19:37:33 +0000
Received: by dajr28 with SMTP id r28so1091968daj.19
	for <pgsql-sql@postgresql.org>; Thu, 01 Mar 2012 11:37:16 -0800 (PST)
Received-SPF: pass (google.com: domain of carlos.mennens@gmail.com designates
	10.68.130.164 as permitted sender) client-ip=10.68.130.164;
Authentication-Results: mr.google.com; spf=pass (google.com: domain of
	carlos.mennens@gmail.com designates 10.68.130.164 as permitted
	sender) smtp.mail=carlos.mennens@gmail.com;
	dkim=pass header.i=carlos.mennens@gmail.com
Received: from mr.google.com ([10.68.130.164])
	by 10.68.130.164 with SMTP id of4mr6530062pbb.56.1330630636949
	(num_hops = 1); Thu, 01 Mar 2012 11:37:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type; bh=5labENlrFU2bKV3S0xO6IaXhKa6cW8JULF0GRFV7mFQ=;
	b=M7O4RYO6FTv65R9gxMTkxQL9kbt2EVzK9c7/2LwWGscGiqq3CvtdzCWbkByqt3Io9X
	FgUnGdacKGnpzg/+45y04vTqiopYaa1mh7/3TCu2WGnStJdx216NA4r50TEZirpn29dT
	WwLdCc0mRVbwnSqnSwGH39uJUugYXax2w97lF1K9fBwGp2cdBhVHXEyohIqF8MI0c02B
	Vp/Au6eE7yQttLgzX/7hbs0SDSZBy0/zO8ahoW6OzQa6eHaByDQqBrYCtGHbb9FMynQ1
	R5YZmzJhWxjFRCTqHGh6vEr4DBCd27XvZcJbc6VCYT84CqB+ud6IlukfueCc/3nsceyf
	cE8g==
MIME-Version: 1.0
Received: by 10.68.130.164 with SMTP id of4mr5371607pbb.56.1330630636834; Thu,
	01 Mar 2012 11:37:16 -0800 (PST)
Received: by 10.68.43.100 with HTTP; Thu, 1 Mar 2012 11:37:16 -0800 (PST)
In-Reply-To: <4F4FC1A1.6070702@gmail.com>
References: 
 <CAAQLLO7gqap3zYUGGd0fuTZjS8OWt86OUtvNQubLEGf40AyNfA@mail.gmail.com>
	<4F4FA622.70002@affinitas.de>
	<CAAQLLO7W6pAKz26k=JV8W_47O+DT6kOf--U3QKkmgXq_s7LfMw@mail.gmail.com>
	<4F4FC1A1.6070702@gmail.com>
Date: Thu, 1 Mar 2012 14:37:16 -0500
Message-ID: 
 <CAAQLLO5j9N4FACujBrsnz+aYVV4mYHa8f1TgmLP16AX97Z7qrg@mail.gmail.com>
Subject: Re: Change Ownership Recursively
From: Carlos Mennens <carlos.mennens@gmail.com>
To: "PostgreSQL (SQL)" <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201203/14
X-Sequence-Number: 36409

I changed to the suggested database which is owned by 'Carlos' and did
as instructed. Everything worked fine. Thank you!

On Thu, Mar 1, 2012 at 11:23 AM, Carlos Mennens
<carlos.mennens@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.klaver@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.