From: | Craig White <craigwhite(at)azapple(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: dumb question |
Date: | 2006-02-13 02:47:11 |
Message-ID: | 1139798831.20169.69.camel@lin-workstation.azapple.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-02-13 02:58:50 | Re: [GENERAL] Number format problem |
Previous Message | Michael Glaesemann | 2006-02-13 02:39:18 | Re: dumb question |