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

pgsql: Don't allow CREATE TABLE AS to put relations in pg_global.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't allow CREATE TABLE AS to put relations in pg_global.
Date: 2012-03-21 16:40:25
Message-ID: E1SAOaH-0000qu-Hx@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Don't allow CREATE TABLE AS to put relations in pg_global.

This was never intended to be allowed, and is blocked for an ordinary
CREATE TABLE, but CREATE TABLE AS slipped through the cracks.  This
commit won't do anything to fix existing cases where this has loophole
has been exploited, but it still seems prudent to lock it down going
forward.

Back-branch commit only, as this problem has been refactored away
on the master branch.

Andres Freund

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/d4a68363aff508a1179cd5e3f45f61a08104a1e1

Modified Files
--------------
src/backend/executor/execMain.c |    7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-03-21 17:05:41
Subject: pgsql: Back-patch contrib/vacuumlo's new -l (limit) option into 9.0and
Previous:From: Heikki LinnakangasDate: 2012-03-21 15:48:58
Subject: pgsql: Fix bug where walsender goes into a busy loop if connection ist

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