Re: drop user question

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Rob Storrs <rstorrs(at)speakeasy(dot)net>
Cc: frank_lupo <frank_lupo(at)email(dot)it>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop user question
Date: 2003-11-11 00:58:51
Message-ID: 20031111005851.GC9396@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 10, 2003 at 04:45:10PM -0800, Rob Storrs wrote:
> According to my test (pg 7.2.4), the owner of the table will be null
> after the user PIPPO is dropped.

That's what it seems, but in reality the owner is the ID the PIPPO had.
If you create another user with the same ID, he will be the new owner of
the table.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-11 01:16:11 PostgreSQL v7.4 Release Candidate 2
Previous Message Joshua D. Drake 2003-11-11 00:56:47 Re: PL/Perl returning multiple rows