owner orphaned databases - Mailing list pgsql-general

From CSN
Subject owner orphaned databases
Date
Msg-id 20040827014908.25962.qmail@web52909.mail.yahoo.com
Whole thread Raw
Responses Re: owner orphaned databases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: Paul Tillotson
Date:
Subject: Re: performance of IN (subquery)
Next
From: CSN
Date:
Subject: Re: owner orphaned databases