Re: Scope of constraint names - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Scope of constraint names
Date
Msg-id 3960.1025800971@sss.pgh.pa.us
Whole thread Raw
In response to Re: Scope of constraint names  (Rod Taylor <rbt@zort.ca>)
Responses Re: Scope of constraint names  (Rod Taylor <rbt@zort.ca>)
List pgsql-hackers
Rod Taylor <rbt@zort.ca> writes:
> I think it would be a rare event to have more than one person changing
> the database structure at the same time.

I don't buy this assumption --- consider for example two clients
creating temp tables.

> Anyway, the index example is a
> bad example isn't it?  It already takes an lock on pg_class which is
> just as global.

Au contraire; there is no exclusive lock needed at present.
        regards, tom lane




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: BETWEEN Node & DROP COLUMN
Next
From: "J. R. Nield"
Date:
Subject: Re: Issues Outstanding for Point In Time Recovery (PITR)