Thread: ALTER TABLE OWNER patch

I sent to the following patch to the PATCHES list.


This patch implements the following command:

ALTER TABLE <tablename> OWNER TO <username>

Only a superuser may execute the command.

-- 
Mark Hollomon
mhh@mindspring.com

I know that this feature is often asked for, but be aware that it is
incompatible with the future, namely SQL schema support. Under that
scheme, a schema has an owner and all objects belong to a schema. I guess
at that point we'd have to disable this command with a reference to some
sort of command to move objects between schemas.


Mark Hollomon writes:

> I sent to the following patch to the PATCHES list.
> 
> 
> This patch implements the following command:
> 
> ALTER TABLE <tablename> OWNER TO <username>
> 
> Only a superuser may execute the command.
> 
> 

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/