> 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...
That was my feeling. Imagine another issue. If you see a file, how do
you figure out what database it belong to? You would have to cycle
through the pg_class relations for every database. Seems such reverse
lookups would not be impossible. Not sure if it will ever be required.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026