| From: | "frank_lupo" <frank_lupo(at)email(dot)it> |
|---|---|
| To: | "alvherre" <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | "rstorrs" <rstorrs(at)speakeasy(dot)net> |
| Subject: | Re: drop user question |
| Date: | 2003-11-11 07:36:20 |
| Message-ID: | HO6FSK$232C6FAEB929A8B7897110AC06E2EAD0@email.it |
| 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.
Thanks,
In other database is not possible drop user if user have permision on object database.
> --
> Alvaro Herrera ()
> "No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)
>
Bye !!
Frank Lupo (Wolf) !!
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Il notebook che hai sempre desiderato lo trovi su Ebest
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=551&d=11-11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2003-11-11 07:55:50 | ALTER TABLE ADD UNIQUE ..... |
| Previous Message | Joe Conway | 2003-11-11 07:01:45 | Re: PL/Perl returning multiple rows |