On Mon, 2006-02-13 at 11:39 +0900, Michael Glaesemann wrote: > 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. ---- seems to be a lot of work just for this...the problem is trying to use rubyonrails and their 'migrations' which cause this... $ rake clone_structure_to_test --trace (in /home/craig/ruby-db/th-db) ** Invoke clone_structure_to_test (first_time) ** Invoke db_structure_dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_structure_dump ** Invoke purge_test_database (first_time) ** Invoke environment ** Execute purge_test_database ** Execute clone_structure_to_test psql:db/development_structure.sql:28: NOTICE: CREATE TABLE will create implicit sequence "case_managers_id_seq" for "serial" column "case_managers.id" psql:db/development_structure.sql:57: NOTICE: CREATE TABLE will create implicit sequence "placements_id_seq" for "serial" column "placements.id" psql:db/development_structure.sql:70: NOTICE: CREATE TABLE will create implicit sequence "referral_notes_id_seq" for "serial" column "referral_notes.id" psql:db/development_structure.sql:86: NOTICE: CREATE TABLE will create implicit sequence "clients_id_seq" for "serial" column "clients.id" psql:db/development_structure.sql:103: NOTICE: CREATE TABLE will create implicit sequence "facilities_id_seq" for "serial" column "facilities.id" psql:db/development_structure.sql:122: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "case_managers_pkey" for table "case_managers" psql:db/development_structure.sql:131: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "placements_pkey" for table "placements" psql:db/development_structure.sql:140: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "referral_notes_pkey" for table "referral_notes" psql:db/development_structure.sql:149: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "clients_pkey" for table "clients" psql:db/development_structure.sql:158: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "facilities_pkey" for table "facilities" psql:db/development_structure.sql:211: ERROR: must be owner of schema public So how can I just 'munge' the system tables? I have granted all privileges to this user. Thanks Craig
