ALTER OBJECT SET SCHEMA

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: pgsql-patches(at)postgresql(dot)org
Subject: ALTER OBJECT SET SCHEMA
Date: 2005-07-03 15:29:35
Message-ID: 369141D8A5DE6A09F07DE2E0@sparkey.oopsware.intra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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 Content-Type Size
pgsql_alter.patch.bz2 application/octet-stream 9.3 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-07-03 16:10:28 Re: [HACKERS] Dbsize backend integration
Previous Message Marko Kreen 2005-07-03 13:06:27 Re: contrib/pgcrypto patch for OpenSSL 0.9.8