From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: owner orphaned databases |
Date: | 2004-08-27 01:56:17 |
Message-ID: | 20040827015617.81991.qmail@web52907.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hmm, for some reason the "deleted" user does in fact
exist but isn't getting added in the "CREATE USER"
section of the dumpall file. It has a user id of "1"
if that makes any difference.
CSN
--- CSN wrote:
> Not a big deal, but I'm transferring a dumpall and
> it's choking on databases where the owner no longer
> exists. Maybe it shouldn't be possible to delete a
> user while it still owns databases, or maybe a
> cascade
> option, or requiring changing the ownership to
> another
> user?
>
> CREATE DATABASE "orphan" WITH OWNER = "deleted" ...;
> ...
> SET SESSION AUTHORIZATION "deleted";
> ...
> \c orphan # fails because "orphan" wasn't created
>
>
> CSN
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Ward | 2004-08-27 02:14:15 | Re: performance of IN (subquery) |
Previous Message | CSN | 2004-08-27 01:49:08 | owner orphaned databases |