ALTER OBJECT SET SCHEMA

Here is an updated version of your patch. Would you supply SGML
documentation updates to match the code changes? Thanks.

---------------------------------------------------------------------------

Bernd Helmle wrote:

Here's my current patch for ALTER OBJECT SET SCHEMA: the attached patch
file implements
schema "move" for FUNCTION, SEQUENCE, TYPE, DOMAIN and TABLE with all
improvements discussed on -hackers recently. Altering OPERATOR, OPERATOR
CLASS, AGGREGATE and CONVERSION are currently not implemented (since i ran
out of time) :(

Supported syntax is

ALTER TABLE name SET SCHEMA name;
ALTER SEQUENCE name SET SCHEMA name;
ALTER FUNCTION name SET SCHEMA name;
ALTER TYPE name SET SCHEMA name;
ALTER DOMAIN name SET SCHEMA name;

TIA

--
Bernd

[ Attachment, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bernd Helmle wrote:

--On Donnerstag, Juli 28, 2005 23:12:37 -0400 Bruce Momjian
<pgman@candle.pha.pa.us> wrote:

Here is an updated version of your patch. Would you supply SGML
documentation updates to match the code changes? Thanks.

Bruce, is there any requirement to add some regression tests, too?

It would be nice, yes.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

--On Donnerstag, Juli 28, 2005 23:12:37 -0400 Bruce Momjian
<pgman@candle.pha.pa.us> wrote:

Here is an updated version of your patch. Would you supply SGML
documentation updates to match the code changes? Thanks.

Bruce, is there any requirement to add some regression tests, too?

--
Bernd

--On Donnerstag, Juli 28, 2005 23:12:37 -0400 Bruce Momjian
<pgman@candle.pha.pa.us> wrote:

Here is an updated version of your patch. Would you supply SGML
documentation updates to match the code changes? Thanks.

Here's my first shot on this. Let me know if there's somenthing missing or
broken (note: English is not my native language, i hope there aren't too
much faults....).

--
Bernd

Bernd Helmle <mailings@oopsware.de> writes:

Here is an updated version of your patch. Would you supply SGML
documentation updates to match the code changes? Thanks.

Here's my first shot on this.

Applied with additional minor editing.

regards, tom lane