ALTER TABLE OWNER patch

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/