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