ALTER TABLE .. SET SCHEMA lock strength

Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

The world's most advanced open source database.

ALTER TABLE .. SET SCHEMA lock strength

From:	Robert Haas <robertmhaas(at)gmail(dot)com>
To:	pgsql-hackers(at)postgresql(dot)org
Subject:	ALTER TABLE .. SET SCHEMA lock strength
Date:	2011-01-01 16:06:57
Message-ID:	AANLkTikzah19LWxJ+tD=r4p9ygcY1YY6L1oCqVTM42v+@mail.gmail.com (view raw or flat)
Thread:
Lists:	pgsql-hackers

While reviewing the SQL/MED patch, I happened to notice that
ExecAlterObjectSchemaStmt calls AlterTableNamespace with a lock mode
argument of AccessExclusiveLock. Does anyone see a reason why
ShareUpdateExclusiveLock would be insufficient?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Responses

Re: ALTER TABLE .. SET SCHEMA lock strength at 2011-01-01 17:17:53 from Simon Riggs

pgsql-hackers by date

Next: From: Dimitri Fontaine Date: 2011-01-01 16:28:42

Subject: Re: Sync Rep Design

Previous: From: Guillaume Lelarge Date: 2011-01-01 15:31:29

Subject: Re: and it's not a bunny rabbit, either

Next:	From: Dimitri Fontaine	Date: 2011-01-01 16:28:42
	Subject: Re: Sync Rep Design
Previous:	From: Guillaume Lelarge	Date: 2011-01-01 15:31:29
	Subject: Re: and it's not a bunny rabbit, either

Search

Peripheral Links

ALTER TABLE .. SET SCHEMA lock strength

Responses

pgsql-hackers by date