On Feb 13, 2006, at 11:27 , Craig White wrote:
> th-db_test=> ALTER SCHEMA public OWNER TO tobyhouse;
> ERROR: syntax error at or near "OWNER" at character 21
>
> # rpm -q postgresql-server
> postgresql-server-7.4.8-1.RHEL4.1
The docs I referred you to are for the current release. For earlier
releases, such as 7.4, you need to refer to the appropriate docs,
such as:
http://www.postgresql.org/docs/7.4/interactive/sql-alterschema.html
It appears that the ability to assign a new owner to a schema via
ALTER SCHEMA was introduced some time after 7.4.
You may be able to munge the system tables, but you may want to
consider upgrading your PostgreSQL server installation.
Michael Glaesemann
grzm myrealbox com