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-0000qx-K3@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
------
REL8_4_STABLE

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

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