Re: pgsql: Update for roles: < * Prevent default re-use - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Update for roles: < * Prevent default re-use
Date
Msg-id 20751.1120246489@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Update for roles: < * Prevent default re-use  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-committers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The problem is this used in pg_dumpall --clean:

>     DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');

Hmm.  I haven't gotten around to looking at pg_dumpall issues, but we
might have to add an ON DELETE rule to the pg_shadow view to allow old
dump files to continue working.

IIRC, there are *really* old dump files that try to do COPY TO
pg_shadow, but I'm assuming we don't care about supporting stuff
that far back.

            regards, tom lane

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Remove contrib version of rtree_gist --- now in core system.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Update for roles: < * Allow limits on per-db/user connections >