Updating the owner of a function
От | Mike Mascari |
---|---|
Тема | Updating the owner of a function |
Дата | |
Msg-id | 4003C385.2020000@mascari.com обсуждение исходный текст |
Ответы |
Re: Updating the owner of a function
|
Список | pgsql-general |
While migrating to 7.4, which performs quite nicely btw, I must have performed some sequence of the migration incorrectly. Now, when I use pg_dump on a database for backup, I get: pg_dump: WARNING: owner of data type "plr_environ_type" appears to be invalid pg_dump: WARNING: owner of data type "r_typename" appears to be invalid pg_dump: WARNING: owner of function "plr_call_handler" appears to be invalid pg_dump: WARNING: owner of function "reload_plr_modules" appears to be invalid pg_dump: WARNING: owner of function "install_rcmd" appears to be invalid pg_dump: WARNING: owner of function "plr_singleton_array" appears to be invalid pg_dump: WARNING: owner of function "plr_array_push" appears to be invalid pg_dump: WARNING: owner of function "plr_array_accum" appears to be invalid pg_dump: WARNING: owner of function "r_typenames" appears to be invalid pg_dump: WARNING: owner of function "load_r_typenames" appears to be invalid pg_dump: WARNING: owner of function "s_riupdate" appears to be invalid pg_dump: WARNING: owner of function "plr_environ" appears to be invalid Becuase the original owner does not exist (uid 100) in pg_user. I was wondering if it would be safe to do: UPDATE pg_proc SET proowner = <appropriate owner id> WHERE proowner = 100; Or should I dump and reload the database with an edited dump file, which is dumping: SET SESSION_AUTHORIZATION "100"; Thanks! Mike Mascari
В списке pgsql-general по дате отправления: