Postgres Pro
Downloads
Home   >   mailing lists

ALTER TABLE lock level - Mailing list pgsql-docs

From Marko Tiikkaja
Subject ALTER TABLE lock level
Date
Msg-id 51A37A72.5000203@joh.to
Whole thread Raw
Responses Re: ALTER TABLE lock level
List pgsql-docs
Tree view 
Hi,

Today I got (unfortunately) reminded that this statement, in
sql-altertable.html under VALIDATE CONSTRAINT, is not true anymore:

The value of separating validation from initial creation of the
constraint is that validation requires a lesser lock on the table than
constraint creation does.

Seems to affect all versions >= 9.1.



Regards,
Marko Tiikkaja

pgsql-docs by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: The Parser Stage: "plain ASCII text" ?
Next
From: Peter Eisentraut
Date:
Subject: Re: Contradicting information for DEFERRABLE constraints