Re: [GENERAL] drop user question

2003-11-11 Thread frank_lupo
> > 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

Re: [GENERAL] drop user question

2003-11-11 Thread frank_lupo
> 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

[GENERAL] drop user question

2003-11-10 Thread frank_lupo
I have create user PIPPO: CREATE USER PIPPO; I have create a table: create table aa (id int4); Change owner of table to user PIPPO. alter table aa owner pippo; I drop user PIPPO. Who is the owner of the table? Thanks. Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-ooo--