Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks
Date
Msg-id 23226.1144205619@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks  ("Thomas F. O'Connell" <tfo@sitening.com>)
List pgsql-general
Tree view 
"Thomas F. O'Connell" <tfo@sitening.com> writes:
> I've brought this up to an extent in the past, but is there an easy
> way to extend section 12.3.1 (or create some form of appendix) such
> that it reveals all possible locking paths for SQL commands in
> postgres?

It's very simple: any form of schema alteration on a table takes
exclusive lock.  Offhand the only exception I can remember is CREATE
INDEX, and frankly I'm not 100% sure that is a safe exception.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jonel Rienton"
Date:
Subject: Re: Duda, version para Solaris 10
Next
From: Michael Fuhr
Date:
Subject: Re: RAISE function misuse ?