From:
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To:
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Cc:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: ALTER OBJECT any_name SET SCHEMA name
Date:
2010-11-03 16:10:12
Message-ID:
m2lj5atml7.fsf@hi-media.com (view raw or flat )
Thread:
2010-10-30 21:05:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-30 22:59:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-31 12:46:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 16:59:45 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-31 17:16:36 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 17:38:18 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 17:46:31 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-31 18:19:08 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 19:10:07 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-31 19:42:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 20:35:28 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-10-31 21:46:56 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 22:02:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-31 22:09:23 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-02 13:03:44 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-03 16:10:12 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-03 21:18:32 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-03 21:32:25 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 14:06:48 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 14:27:45 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-04 14:37:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 14:51:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-04 15:16:17 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 19:39:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 21:55:36 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-05 09:44:22 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-21 04:22:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-21 04:23:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-21 12:53:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-21 18:03:17 from David Fetter <david(at)fetter(dot)org>
2010-11-21 18:36:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-21 18:45:30 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-21 21:47:56 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-23 03:31:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-23 08:18:56 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-25 22:00:06 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-26 22:56:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-27 19:17:48 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-28 13:06:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-04 15:48:12 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-04 14:39:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-04 14:52:53 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 15:05:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-04 15:18:13 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 15:33:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-04 15:50:51 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-04 19:57:10 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 19:42:53 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-04 21:57:33 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-05 09:49:34 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-05 16:03:38 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-05 16:16:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-05 16:48:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-05 17:06:59 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-05 17:16:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-05 18:14:43 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-05 19:30:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-11-05 19:58:00 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-11-05 20:04:48 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-05 20:15:30 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 15:15:48 from Bernd Helmle <mailings(at)oopsware(dot)de>
2010-10-31 16:45:53 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-10-31 18:42:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-31 19:38:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
Lists:
pgsql-hackers
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> writes:
> Please find attached v12 of the patch, which implements that idea.
And v13 now. v12 was intended to see what you think about the new
pg_execute_from_file placeholder API and replace_text usage, v13 fixes
the pg_dump support by adding dependencies.
Also, I've been changing the \dx output to show the schema where an
extension's objects are living rather than the custom_variable_classes
that most users won't care about, I think.
Then, I think the ALTER EXTENSION foo SET SCHEMA name still has a use
case, so I've prepared a simple patch to show the API usage before we
get to refactor it all following Tom's asking. So there's a initial
patch to see that in action. I had to rework AlterFunctionNamespace()
API so that I can call it from elsewhere in the backend where I have
Oids, so here's an updated set_schema.4.patch. We will have to extend
the APIs for relations and types the same way, but it's already possible
to test the patch with some extensions this way.
Producing those patches (the alter_extension patch is an incremental
patch that sits atop both the extension and the set_schema one) is made
easy enough with git, I'm impressed by this tool.
http://git.postgresql.org/gitweb?p=postgresql-extension.git;a=summary
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-11-03 16:28:42
Subject : Re: why does plperl cache functions using just a bool for is_trigger
Previous :From : Tom LaneDate : 2010-11-03 14:42:12
Subject : Re: improved parallel make support