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

Re: missing rename support

From: Ali Dar <ali(dot)munir(dot)dar(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: missing rename support
Date: 2013-01-03 13:49:07
Message-ID: CAAj60S5nndCr0me5qsVPy5rPVJjtOGCjDin-zJQGWEP7bhdijw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, Dec 3, 2011 at 4:46 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> I noticed the following object types don't have support for an ALTER ...
> RENAME command:
>
> DOMAIN (but ALTER TYPE works)
> FOREIGN DATA WRAPPER
> OPERATOR
> RULE
> SERVER
>
> Are there any restrictions why these couldn't be added?

> I don't think so.  There's no ALTER RULE command; should we add one
(matching ALTER TRIGGER) or make this part of ALTER TABLE?  I don't
think constraints can be renamed either, which should probably be
addressed along with rules.

> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company

Find attached an initial patch for ALTER RENAME RULE feature. Please
note that it does not have any documentation yet.

Attachment: Alter_Rule_Rename.patch
Description: application/octet-stream (4.0 KB)

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2013-01-03 14:09:22
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Previous:From: Hannu KrosingDate: 2013-01-03 13:46:20
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"

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