| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| Alter_Rule_Rename.patch | application/octet-stream | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-01-03 14:09:22 | Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database" |
| Previous Message | Hannu Krosing | 2013-01-03 13:46:20 | Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database" |