It is an idea if no better one can be found, unless we don't want ALTER DOMAIN at all, which doesn't seem good.
--------------------------------------------------------------------------- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I have an idea. Rather than doing some complex locking for types, why > > don't we just restrict ALTER DOMAIN to cases where we are the only one > > attached to the database, as seen in dropdb(). > > Yech! > > > would allow the regression test to work too because no one is attached > > to 'regression' at the time of the test. > > No, we'd just get random reports of unreproducible failures. > > FWIW, I frequently attach to the regression database with a manual psql > while the regression tests are running. It's a useful thing to do --- > I've more than once found bugs that way. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])