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

pgsql: Improve behavior of concurrent ALTER <relation> .. SET SCHEMA.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve behavior of concurrent ALTER <relation> .. SET SCHEMA.
Date: 2011-12-16 00:03:26
Message-ID: E1RbLGo-0006Dx-MP@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Improve behavior of concurrent ALTER <relation> .. SET SCHEMA.

If the referrent of a name changes while we're waiting for the lock,
we must recheck permissons.  We also now check the relkind before
locking, since it's easy to do that long the way.

Patch by me; review by Noah Misch.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1da5c119594e4fb07fb6a2c57f66642fa5e966fb

Modified Files
--------------
src/backend/commands/alter.c     |    1 -
src/backend/commands/tablecmds.c |  113 +++++++++++++++++++++++--------------
2 files changed, 70 insertions(+), 44 deletions(-)

pgsql-committers by date

Next:From: Andrew DunstanDate: 2011-12-16 01:12:15
Subject: pgsql: include_if_exists facility for config file.
Previous:From: Robert HaasDate: 2011-12-15 23:45:45
Subject: pgsql: Don't leave regress_test_role_super lying around.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group