Re: drop user question

According to my test (pg 7.2.4), the owner of the table will be null
after the user PIPPO is dropped.

test=# \dt aa
   List of relations
  Name | Type  | Owner
------+-------+-------
  aa   | table | pippo

test=# drop user PIPPO;
DROP USER

test=# \dt aa
   List of relations
  Name | Type  | Owner
------+-------+-------
  aa   | table |

Hope that helps.
~R

ps. I had to change the syntax of your alter table statement to "alter
table aa owner to pippo;" for it to work.


frank_lupo wrote:

> 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---
>
>
>
> --
> Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>
> Sponsor:
> Usi ancora fax e carta? Allora sei preistorico! Oggi i fax li ricevi direttamente sul computer con il nuovo EmailFax
IN
> Clicca e scopri i vantaggi
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1568&d=10-11
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>