Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
In response to
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2005-07-01 19:40:57|
|Subject: Re: pgsql: Update for roles: < * Allow limits on per-db/user connections > |
|Previous:||From: Tom Lane||Date: 2005-07-01 19:23:07|
|Subject: pgsql: Remove contrib version of rtree_gist --- now in core system.|