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 <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073