From: | Michael Robinton <michael(at)bizsystems(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | problem with upgrade from 6.5 -> 7.2 |
Date: | 2002-03-10 23:47:41 |
Message-ID: | Pine.LNX.4.33.0203101537370.518-100000@pandora.is.bizsystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
this set of permissions exists under 6.5
bzsdb02=> \z
Database = bzsdb02
+------------------------+----------------------------------------+
| Relation | Grant/Revoke Permissions |
+------------------------+----------------------------------------+
| name_server | {"=","namereader=r","nameadmin=arwR"} |
| name_server_serial_seq | |
| nsconfig | {"=","namereader=r","nameadmin=arwR"} |
| nsnotify | {"=","namereader=rw","nameadmin=arwR"} |
+------------------------+----------------------------------------+
and under 7.2
bzsdb02=# \z
Access privileges for database "bzsdb02"
Table | Access privileges
------------------------+-------------------------------------------------------
name_server | {=,postgres=arwdRxt,namereader=r,nameadmin=arwdRxt}
name_server_serial_seq |
nsconfig | {=,postgres=arwdRxt,namereader=r,nameadmin=arwdRxt}
nsnotify | {=,postgres=arwdRxt,namereader=rwd,nameadmin=arwdRxt}
(4 rows)
note that "name_server_serial_seq" appear to be identical
However, when I attempt to update the database in 7.2 I get this error:
DBD::Pg::st execute failed: ERROR: name_server_serial_seq.nextval: you
don't have permissions to set sequence name_server_serial_seq
Any ideas?
I suppose I could add the permissions but it seems they should follow
along from the CREATE sequence statement ???
Thanks,
Michael
The dump looks like this
CREATE SEQUENCE "name_server_serial_seq" start 5202 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"name_server_serial_seq"');
CREATE TABLE "name_server" (
... blah, blah....
"serial" int8 DEFAULT nextval ( 'Name_Server_Serial_Seq' ));
REVOKE ALL on "name_server" from PUBLIC;
GRANT SELECT on "name_server" to "namereader";
GRANT ALL on "name_server" to "nameadmin";
... table gets loaded....
CREATE UNIQUE INDEX "name_server_key" on "name_server" using btree (
"serial" "int8_ops" );
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Robinton | 2002-03-11 00:32:05 | problem with upgrade from 6.5 -> 7.2 (fwd) |
Previous Message | Doug McNaught | 2002-03-10 23:36:18 | Re: "View" in server level |