Re: Problems with ALTER DOMAIN patch

Bruce Momjian <pgman@candle.pha.pa.us> 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