Re: ALTER OBJECT any_name SET SCHEMA name

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Dimitri Fontaine <dimitri@2ndquadrant.fr>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-04T21:55:36Z
Lists: pgsql-hackers
Excerpts from Dimitri Fontaine's message of jue nov 04 16:39:31 -0300 2010:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
> > Not having read the patch, but ... the idea that was in the back of
> > my mind was to have a generic AlterObjectNamespace function that
> > would take parameters approximately like the following:
> 
> Please find attached what I came up with, that's the set_schema patch
> version 6.

Neat.

The has_privs_of_role() call has the wrong ACL_KIND argument in the
error report.

(Nitpick: don't use "e.g." at the end of the phrase.  It seems strange
to me.)

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support