From:
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Erik Rijkers <er(at)xs4all(dot)nl>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>,pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>,Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>
Subject:
Re: erroneous restore into pg_catalog schema
Date:
2013-01-14 19:07:29
Message-ID:
20130114190729.GF5106@alvh.no-ip.org (view raw or flat )
Thread:
2013-01-13 10:17:31 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2013-01-13 15:53:30 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-13 17:29:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-13 20:50:06 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-13 21:09:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-13 21:18:15 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-13 21:23:30 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2013-01-13 21:37:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-14 15:35:57 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-14 16:02:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-14 16:08:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-14 16:55:46 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-14 17:28:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-14 17:44:21 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-14 19:07:29 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-15 20:09:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-15 20:22:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-15 20:40:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-29 19:30:16 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-29 22:37:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-29 23:00:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-04-17 14:45:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-04-17 18:06:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-04-22 15:15:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-05-04 19:59:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-04 20:57:44 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-05-06 14:37:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-06 14:58:17 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-05-13 19:00:04 from Marko Kreen <markokr(at)gmail(dot)com>
2013-05-14 01:04:06 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-05-14 07:29:38 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-05-14 08:49:48 from Marko Kreen <markokr(at)gmail(dot)com>
2013-05-14 10:59:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-05-14 11:16:55 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-14 12:35:03 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-05-09 15:24:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-05-13 08:49:07 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-05-13 15:48:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 16:20:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-05-13 16:32:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 16:35:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 16:59:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-05-13 17:03:33 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-13 17:04:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-05-13 17:18:28 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-13 17:40:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 17:50:32 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-13 18:35:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 18:43:55 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-13 18:48:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 18:55:01 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-05-13 19:16:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 17:27:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-05-13 17:32:24 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-15 20:04:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-13 21:31:45 from Andres Freund <andres(at)anarazel(dot)de>
Lists:
pgsql-hackers
Tom Lane escribió:
> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> > alvherre=# create extension adminpack;
> > ERROR: permission denied for schema pg_catalog
>
> Um. I knew that that module's desire to shove stuff into pg_catalog
> would bite us someday. But now that I think about it, I'm pretty sure
> I recall discussions to the effect that there are other third-party
> modules doing similar things.
How about we provide a superuser-only function that an extension can
call which will set enableSystemTableMods? It would get back
automatically to the default value on transaction end. That way,
extensions that wish to install stuff in pg_catalog can explicitely
declare it, i, and the rest of the world enjoys consistent protection.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2013-01-14 19:12:24Subject : Re: Hash twicePrevious :From : Tom LaneDate : 2013-01-14 18:53:39Subject : Re: [HACKERS] Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in "34.41. schemata")
