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: | Raw Message | Whole Thread | 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 |