Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)nasby(dot)net
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY
Date: 2003-06-12 22:23:12
Message-ID: 21266.1055456592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> Is there any ALTER that would require blocking selects?

DROP INDEX, for certain.

> Even stuff like
> drop and rename should be protected by versioning, no?

No. System-catalog changes are always READ COMMITTED mode.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yves R. Crevecoeur 2003-06-12 22:51:18 Re: PostgreSQL client has problems when libbind is installed
Previous Message Tom Lane 2003-06-12 22:19:19 Re: Pre-allocation of shared memory ...