Skip site navigation (1) Skip section navigation (2)

Re: ALTER OBJECT SET SCHEMA

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: ALTER OBJECT SET SCHEMA
Date: 2005-07-29 03:12:37
Message-ID: 200507290312.j6T3CbD19841@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-07-29 03:17:40
Subject: Re: regexp_replace
Previous:From: Joshua D. DrakeDate: 2005-07-28 23:57:24
Subject: Re: [PATCHES] COPY FROM performance improvements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group