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).
Petr Jelinek (PJMODOS)
pgsql-patches by date
|Next:||From: Petr Jelinek||Date: 2007-09-29 06:25:14|
|Subject: Add chklocale.c to msvc build|
|Previous:||From: Brendan Jurd||Date: 2007-09-29 03:02:10|
|Subject: Re: [HACKERS] Add function for quote_qualified_identifier?|