problem with upgrade from 6.5 -> 7.2
От | Michael Robinton |
---|---|
Тема | problem with upgrade from 6.5 -> 7.2 |
Дата | |
Msg-id | Pine.LNX.4.33.0203101537370.518-100000@pandora.is.bizsystems.com обсуждение исходный текст |
Список | 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" );
В списке pgsql-general по дате отправления: