Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY
Date
Msg-id 20030616081429.GC25847@wolff.to
Whole thread Raw
In response to Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
Tree view 
On Mon, Jun 16, 2003 at 01:17:38 -0500, "Jim C. Nasby" <jim@nasby.net> wrote:
>  
> Yeah, so the catalog changes shouldn't be visible to anyone until after
> the ALTER is complete, right? Even if a transaction is set to read
> uncommitted, I assume it will always read only committed data from the
> catalogs...

Postgres doesn't have a read uncommitted mode for transactions.

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY
Next
From: Andreas Pflug
Date:
Subject: Re: Groups and roles