From: Kumar <sgnerd@yahoo.com.sg>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: Error message during compressed backup
Date: Tue, 28 Oct 2003 14:45:17 +0530
Message-ID: <036701c39d34$061fe680$7502a8c0@hdsc.com> (raw)
References: <Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain>
Hi Peter Eisentraut,
>>select proowner from pg_proc where proname = 'plpgsql_call_handler';
It gives me an id '101'
While I search for the users in the pg_user, there is no user of id 101
select * from pg_user where usesysid = 101;
No result was fetched.
While I search this way
select * from pg_user where usename like 'postgres'
This give me a result username = postgres usesysid = 1
In comments you said
>> You may want to adjust the owner of the function to a valid user (use
UPDATE).
Do u mean I need to update the table pg_proc, with the following statement
UPDATE pg_proc SET proowner = 1 where proname = 'plpgsql_call_handler';
I am asking this because to ensure not any wrong impact gets into the live
database. Pls advise.
Regards
Kumar
----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: "Senthil Kumar S" <ssakkaravel@ivesia.com>
Cc: "psql" <pgsql-sql@postgresql.org>
Sent: Friday, October 24, 2003 6:01 PM
Subject: Re: [SQL] Error message during compressed backup
> Senthil Kumar S writes:
>
> > $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
/home/db_repository/testdb20031023.sql.tar.gz -u -F c
>
> > WARNING: owner of function "plpgsql_call_handler" appears to be invalid
>
> Run
>
> select proowner from pg_proc where proname = 'plpgsql_call_handler';
>
> which gives you the ID of the user that owns this function. Then run
>
> select * from pg_user;
>
> to get the list of valid users. You may want to adjust the owner of the
> function to a valid user (use UPDATE).
>
> --
> Peter Eisentraut peter_e@gmx.net
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg, peter_e@gmx.net
Subject: Re: Error message during compressed backup
In-Reply-To: <036701c39d34$061fe680$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox