Re: Scope of constraint names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scope of constraint names
Date: 2002-07-04 16:42:51
Message-ID: 3960.1025800971@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <rbt(at)zort(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message J. R. Nield 2002-07-04 17:07:22 Re: Issues Outstanding for Point In Time Recovery (PITR)
Previous Message Tom Lane 2002-07-04 16:34:35 Re: BETWEEN Node & DROP COLUMN