Re: Problems with ALTER DOMAIN patch

Rod Taylor wrote:
-- Start of PGP signed section.
> On Wed, 2002-12-11 at 00:05, Tom Lane wrote:
> > Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > > On Tue, 2002-12-10 at 22:56, Tom Lane wrote:
> > >> relation's pg_class row. We have no such locks on types at present,
> > >> but I think it may be time to invent 'em.
> >
> > > I'd be happy to use them once created.
> >
> > I think you misunderstood me ;=) ... that was a none-too-subtle
>
> Nope... I understood. But it could take quite a while.

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(). Seems like an easy way
to get the feature in without adding a new locking method. Also, it
would allow the regression test to work too because no one is attached
to 'regression' at the time of the test.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073