From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
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 17:28:58
Message-ID:
23980.1358184538@sss.pgh.pa.us (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-06-05 16:12:47 from Greg Stark <stark(at)mit(dot)edu>
2013-06-10 13:03:05 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-06-10 14:02:22 from Greg Stark <stark(at)mit(dot)edu>
2013-06-10 15:00:42 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-06-10 14:45:10 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-06-10 14:58:41 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-06-10 15:19:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-06-11 05:14:21 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-06-11 08:33:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-06-11 08:39:01 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-06-11 11:26:47 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-06-10 13:35:27 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
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-06-03 07:52:35 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-06-03 14:18:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-06-03 14:23:19 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
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
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> The attached patch seems to work:
> alvherre=# create table pg_catalog.foo (a int);
> ERROR: permission denied for schema pg_catalog
> I notice that contrib/adminpack now fails, though (why doesn't this
> module have a regression test?):
> 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.
Anyway, this seems to answer Robert's original question about why
relations were special-cased: there are too many special cases around
this behavior. I think we should seriously consider just reverting
a475c6036.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Dimitri FontaineDate: 2013-01-14 17:44:21Subject : Re: erroneous restore into pg_catalog schemaPrevious :From : Tom LaneDate : 2013-01-14 17:23:17Subject : Re: [PERFORM] Slow query: bitmap scan troubles
