ALTER TABLE lock level

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: pgsql-docs(at)postgresql(dot)org
Subject: ALTER TABLE lock level
Date: 2013-05-27 15:23:30
Message-ID: 51A37A72.5000203@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Pavel Stehule 2013-05-29 08:02:20 remove undocumented assign syntax from plpgsql doc
Previous Message Ian Lawrence Barwick 2013-05-24 20:29:11 The Parser Stage: "plain ASCII text" ?