From ssakkaravel@ivesia.com Thu Oct  23 09:15:44 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 23B37D1B50C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 09:15:44 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 11979-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 06:15:15 -0300 (ADT)
Received: from chn-dns.primus-india.net (chn-dns.primus-india.net
	[203.196.153.7])
	by svr1.postgresql.org (Postfix) with ESMTP id 5FAEBD1B4E4
	for <pgsql-sql@postgresql.org>; Thu, 23 Oct 2003 06:15:11 -0300 (ADT)
Received: from IVESIA67 (ptil-138-190-chn.primus-india.net [203.196.190.138]
	(may be forged))
	by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id h9N8nQjX019539
	for <pgsql-sql@postgresql.org>; Thu, 23 Oct 2003 14:19:31 +0530
Message-ID: <019401c39946$d6d1cce0$7502a8c0@hdsc.com>
From: "Senthil Kumar S" <ssakkaravel@ivesia.com>
To: "psql" <pgsql-sql@postgresql.org>
Subject: Error message during compressed backup
Date: Thu, 23 Oct 2003 14:49:56 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0191_01C39974.ECB16290"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=HOT_NASTY,
	HTML_40_50
X-Spam-Level: *
X-Archive-Number: 200310/314
X-Sequence-Number: 15714

This is a multi-part message in MIME format.

------=_NextPart_000_0191_01C39974.ECB16290
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Friends,

While doing compressed backup for one of the database running at Postgres S=
erver 7.3.4 on RH Linux 7.2, I got the following error., but it backup othe=
r items

--Command to backup
$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f /home/db_repository/testd=
b20031023.sql.tar.gz -u -F c

--Error msg
WARNING: owner of function "plpgsql_call_handler" appears to be invalid

Could anyone tell me why I am getting this. I could able to do normal back =
and restore.

Please shed some light.

Regards
Kumar

------=_NextPart_000_0191_01C39974.ECB16290
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV><FONT size=3D2>Dear Friends,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>While doing compressed backup for one of the database r=
unning=20
at Postgres Server 7.3.4 on RH Linux 7.2, I got the following error., but i=
t=20
backup other items</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>--Command to backup</FONT></DIV>
<DIV><FONT size=3D2>$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v&nbsp;testdb -f=
=20
/home/db_repository/testdb20031023.sql.tar.gz -u -F c</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>--Error msg</FONT></DIV>
<DIV><FONT size=3D2>WARNING: owner of function "plpgsql_call_handler" appea=
rs to=20
be invalid</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Could anyone tell me why I am getting this. I could abl=
e to do=20
normal back and restore.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Please shed some light.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Kumar</FONT></DIV>
<P></P></BODY></HTML>

------=_NextPart_000_0191_01C39974.ECB16290--




From sgnerd@yahoo.com.sg Thu Oct  23 09:52:54 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id ECDCAD1B50C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 09:52:54 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 13541-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 06:52:26 -0300 (ADT)
Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com
	[216.136.174.113])
	by svr1.postgresql.org (Postfix) with SMTP id A505ED1B517
	for <pgsql-sql@postgresql.org>; Thu, 23 Oct 2003 06:52:23 -0300 (ADT)
Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67)
	(sgnerd@203.196.190.138 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 23 Oct 2003 09:52:24 -0000
Message-ID: <024201c3994c$131abef0$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "psql" <pgsql-sql@postgresql.org>
Subject: Fw: Error message during compressed backup
Date: Thu, 23 Oct 2003 15:27:26 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0237_01C3997A.29AAB8E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=HOT_NASTY,
	HTML_40_50
X-Spam-Level: *
X-Archive-Number: 200310/303
X-Sequence-Number: 15703

This is a multi-part message in MIME format.

------=_NextPart_000_0237_01C3997A.29AAB8E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Dear Friends,

While doing compressed backup for one of the database running at Postgres S=
erver 7.3.4 on RH Linux 7.2, I got the following error., but it backup othe=
r items

--Command to backup
$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f /home/db_repository/testd=
b20031023.sql.tar.gz -u -F c

--Error msg
WARNING: owner of function "plpgsql_call_handler" appears to be invalid

Could anyone tell me why I am getting this. I could able to do normal back =
and restore.

Please shed some light.

Regards
Kumar


------=_NextPart_000_0237_01C3997A.29AAB8E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>Dear Friends,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>While doing compressed backup for one of the database r=
unning=20
at Postgres Server 7.3.4 on RH Linux 7.2, I got the following error., but i=
t=20
backup other items</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>--Command to backup</FONT></DIV>
<DIV><FONT size=3D2>$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v&nbsp;testdb -f=
=20
/home/db_repository/testdb20031023.sql.tar.gz -u -F c</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>--Error msg</FONT></DIV>
<DIV><FONT size=3D2>WARNING: owner of function "plpgsql_call_handler" appea=
rs to=20
be invalid</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Could anyone tell me why I am getting this. I could abl=
e to do=20
normal back and restore.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Please shed some light.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Kumar</FONT></DIV>
<P></P>
<P></P></BODY></HTML>

------=_NextPart_000_0237_01C3997A.29AAB8E0--




From dev@archonet.com Thu Oct  23 11:25:56 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D5198D1B4FD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 11:25:56 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 27269-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Oct 2003 08:25:27 -0300 (ADT)
Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net
	[194.217.242.92])
	by svr1.postgresql.org (Postfix) with ESMTP id 75119D1B510
	for <pgsql-sql@postgresql.org>; Thu, 23 Oct 2003 08:25:24 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1)
	id 1ACdao-000AiV-0Y; Thu, 23 Oct 2003 12:25:27 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id F0B9417865; Thu, 23 Oct 2003 12:25:25 +0100 (BST)
Received: from client17.archonet.com (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 405C217863; Thu, 23 Oct 2003 12:25:25 +0100 (BST)
From: Richard Huxton <dev@archonet.com>
To: "Kumar" <sgnerd@yahoo.com.sg>, "psql" <pgsql-sql@postgresql.org>
Subject: Re: Fw: Error message during compressed backup
Date: Thu, 23 Oct 2003 12:25:23 +0100
User-Agent: KMail/1.5
References: <024201c3994c$131abef0$7502a8c0@hdsc.com>
In-Reply-To: <024201c3994c$131abef0$7502a8c0@hdsc.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200310231225.23602.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/304
X-Sequence-Number: 15704

On Thursday 23 October 2003 10:57, Kumar wrote:
> Dear Friends,
>
> While doing compressed backup for one of the database running at Postgres
> Server 7.3.4 on RH Linux 7.2, I got the following error., but it backup
> other items
>
> --Command to backup
> $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
> /home/db_repository/testdb20031023.sql.tar.gz -u -F c
>
> --Error msg
> WARNING: owner of function "plpgsql_call_handler" appears to be invalid

In psql, do:
\df+ plpgsql*

This will show you the owner (among other details) - it should probably be 
"postgres".

-- 
  Richard Huxton
  Archonet Ltd



From peter_e@gmx.net Fri Oct  24 12:31:55 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id E76F6D1B537
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Oct 2003 12:31:55 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 75909-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Oct 2003 09:31:28 -0300 (ADT)
Received: from mail.gmx.net (mail.gmx.de [213.165.64.20])
	by svr1.postgresql.org (Postfix) with SMTP id C8D06D1B520
	for <pgsql-sql@postgresql.org>; Fri, 24 Oct 2003 09:31:23 -0300 (ADT)
Received: (qmail 9012 invoked by uid 65534); 24 Oct 2003 12:31:26 -0000
Received: from dsl-082-082-165-068.arcor-ip.net (EHLO
	dsl-082-082-165-068.arcor-ip.net) (82.82.165.68)
	by mail.gmx.net (mp023) with SMTP; 24 Oct 2003 14:31:26 +0200
X-Authenticated: #495269
Date: Fri, 24 Oct 2003 14:31:26 +0200 (CEST)
From: Peter Eisentraut <peter_e@gmx.net>
X-X-Sender: peter@peter.localdomain
To: Senthil Kumar S <ssakkaravel@ivesia.com>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: Error message during compressed backup
In-Reply-To: <019401c39946$d6d1cce0$7502a8c0@hdsc.com>
Message-ID: <Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/318
X-Sequence-Number: 15718

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




From ssakkaravel@ivesia.com Tue Oct  28 08:57:58 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 17B41D1B545
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 08:57:58 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 47200-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 04:57:28 -0400 (AST)
Received: from chn-dns.primus-india.net (chn-dns.primus-india.net
	[203.196.153.7])
	by svr1.postgresql.org (Postfix) with ESMTP id C7155D1B53F
	for <pgsql-sql@postgresql.org>; Tue, 28 Oct 2003 04:57:24 -0400 (AST)
Received: from IVESIA67 (ptil-138-190-chn.primus-india.net [203.196.190.138]
	(may be forged))
	by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id h9S8UjjX028676;
	Tue, 28 Oct 2003 14:00:47 +0530
Message-ID: <02ec01c39d31$23d3fe80$7502a8c0@hdsc.com>
From: "Senthil Kumar S" <ssakkaravel@ivesia.com>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "psql" <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain>
Subject: Re: Error message during compressed backup
Date: Tue, 28 Oct 2003 14:24:43 +0530
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/19
X-Sequence-Number: 15834

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
>




From sgnerd@yahoo.com.sg Tue Oct  28 09:18:24 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id AF7D3D1B54B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 09:18:24 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 47212-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 28 Oct 2003 05:17:54 -0400 (AST)
Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com
 [216.136.173.32])
	by svr1.postgresql.org (Postfix) with SMTP id 90306D1B53A
	for <pgsql-sql@postgresql.org>; Tue, 28 Oct 2003 05:17:51 -0400 (AST)
Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67)
	(sgnerd@203.196.190.138 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 28 Oct 2003 09:17:52 -0000
Message-ID: <036701c39d34$061fe680$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "psql" <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain>
Subject: Re: Error message during compressed backup
Date: Tue, 28 Oct 2003 14:45:17 +0530
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/357
X-Sequence-Number: 15757

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
>