Horton

Re: Big 7.1 open items

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>, "'Peter Eisentraut'" <peter_e@gmx.net>, "'Hiroshi Inoue'" <Inoue@tpf.co.jp>, 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-28T16:40:53Z
Lists: pgsql-hackers 
> 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, Pennsylvania 19026