| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Updating the owner of a function |
| Date: | 2004-01-13 10:08:05 |
| Message-ID: | 4003C385.2020000@mascari.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton.Nikiforov | 2004-01-13 10:36:20 | Re: insertion with trigger failed unexpectedly |
| Previous Message | Bernd Helmle | 2004-01-13 09:50:22 | Reallife szenario for GEQO |