X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 7FA2D9DCBCC
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 10 Dec 2005 06:07:48 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 28021-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 10 Dec 2005 06:07:50 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail44.e.nsc.no (mail44.e.nsc.no [193.213.115.44])
	by postgresql.org (Postfix) with ESMTP id 2FD519DCBA6
	for <pgsql-sql@postgresql.org>; Sat, 10 Dec 2005 06:07:45 -0400 (AST)
Received: from [192.168.0.57] (062016183238.customer.alfanett.no
	[62.16.183.238]) (authenticated bits=0)
	by mail44.nsc.no (8.13.5/8.13.5) with ESMTP id jBAA7i4j020572
	for <pgsql-sql@postgresql.org>; Sat, 10 Dec 2005 11:07:46 +0100 (CET)
From: "Leif B. Kristensen" <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Error from trigger
Date: Sat, 10 Dec 2005 11:07:44 +0100
User-Agent: KMail/1.8.1
References: <200512080006.44606.leif@solumslekt.org>
	<200512080043.18481.leif@solumslekt.org>
	<6081.1134015079@sss.pgh.pa.us>
In-Reply-To: <6081.1134015079@sss.pgh.pa.us>
X-Face: %iea8o"[SI'kMDS.`hz7lU=?\^lC9J-]CVjo;
	f{4-C:$?uVUEjyN~uYFn%*aH_c3d09U>=?utf-8?q?x=0A=09TXtaoj=7EMV=2E8PgG7hik9=3BcCT2N6+u?=@Y{wH\p3*_f~FH9k,Wi74e[_l%.7b^'zJ)8S'^G<(=?utf-8?q?=3D=0A=09zw8=5CPMC3=27=7BKl9=2EzL*ks!b6wA?=,c~'F`k&Vq|ELDGa|4<sl_DHXENz#~X_1qmPq+W;
	1LY2D9
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200512101107.44513.leif@solumslekt.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200512/74
X-Sequence-Number: 23616

On Thursday 08 December 2005 05:11, Tom Lane wrote:
>Just starting a fresh session should make the problem go away, or if
>that's not practical update the function definition using ALTER
> FUNCTION or CREATE OR REPLACE FUNCTION.  (You don't need to actually
> *change* anything about the function, just issue a command that could
> change it.)
>
>If that doesn't make the error go away then we need to look more
>closely at what's causing it.

I did an "/etc/init.d/postgresql restart" and the problem went away.

Thanks again.
-- 
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE