ALTER TYPE RENAME

From: Petr Jelinek <pjmodos(at)pjmodos(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Subject: ALTER TYPE RENAME
Date: 2007-09-29 06:22:28
Message-ID: 46FDEF24.5050908@pjmodos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,
I noticed we don't have ALTER TYPE foo RENAME TO bar command which would
be handy for me especially for enum types.
So I wrote this little patch (including very brief doc) which adds above
syntax. It basically just does some checks and calls existing TypeRename
function which is used for renaming table rowtype now.
I hope I haven't missed anything, but I am unsure about two things.
First, this patch allows renaming base types which I don't know if it's
desired. And second we might want to throw error when renaming rowtype
(there is check in AlterTypeOwner for this but not in AlterTypeNamespace
so I don't know).

--
Regards
Petr Jelinek (PJMODOS)

Attachment Content-Type Size
typerename.diff text/plain 5.0 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Petr Jelinek 2007-09-29 06:25:14 Add chklocale.c to msvc build
Previous Message Brendan Jurd 2007-09-29 03:02:10 Re: [HACKERS] Add function for quote_qualified_identifier?