Updating the owner of a function

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

Responses

Browse pgsql-general by date

  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