Re: ALTER OBJECT any_name SET SCHEMA name

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER OBJECT any_name SET SCHEMA name
Date: 2010-11-27 19:17:48
Message-ID: m262vilgo3.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> Committed, after various changes and corrections. One noteworthy one
> is that I removed the _oid variants, since those would be dead code at
> the moment.

Thanks!

The _oid variants will have to re-appear in the "alter extension set
schema" patch, which is the last of the series. Meanwhile, I will have
to merge head with the current extension patch (already overdue for a
new version, waiting on purpose) so that it no longer includes the
cfparser and execute from file patches too (which have changed a lot
underneath it already).

I'm not sure there's lots of precedent for dealing with in-commitfest
patches dependencies, so here's a summary of what I think would ideally
happen next (ordering counts):

1. cfparser
https://commitfest.postgresql.org/action/patch_view?id=413
ready for commiter

2. pg_execute_from_file
https://commitfest.postgresql.org/action/patch_view?id=414
needs another review and maybe some more documentation

3. extensions
https://commitfest.postgresql.org/action/patch_view?id=404
needs review and minor updating
will need another version after merging the two previous patches

4. alter extension set schema
https://commitfest.postgresql.org/action/patch_view?id=416
needs review and a reviewer
will need bitrot fix (and adding in the _oid variants)
would be better to adjust once the 3 previous are in

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-11-27 19:27:12 Report: Linux huge pages with Postgres
Previous Message Bruce Momjian 2010-11-27 19:04:43 Re: autovacuum maintenance_work_mem