RE: Big 7.1 open items

Hiroshi Inoue <inoue@tpf.co.jp>

From: "Hiroshi Inoue" <Inoue@tpf.co.jp>

To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Bruce Momjian" <pgman@candle.pha.pa.us>

Cc: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>, "'Peter Eisentraut'" <peter_e@gmx.net>, "Thomas Lockhart" <lockhart@alumni.caltech.edu>, "Jan Wieck" <JanWieck@Yahoo.com>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>, "Ross J. Reedstrom" <reedstrm@rice.edu>

Date: 2000-06-28T17:28:45Z

Lists: pgsql-hackers

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> However I do see a bit of a problem here: since DROP DATABASE is
> ordinarily executed by a backend that's running in a different database,
> how's it going to read pg_class of the target database?  Perhaps it will
> be necessary to fire up a sub-backend that runs in the target DB for
> long enough to kill all the user tables.  Looking messy...
>

Why do we have to have system tables per *database* ?
Is there anything wrong with global system tables ?
And how about adding dbid to pg_class,pg_proc etc ?

Regards.

Hiroshi Inoue