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])

Reply via email to