X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 480E4D1B27C for ; Wed, 30 Jun 2004 13:04:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49251-05 for ; Wed, 30 Jun 2004 16:04:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 761C3D1B1CE for ; Wed, 30 Jun 2004 13:03:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5UG3w7o009667; Wed, 30 Jun 2004 12:03:59 -0400 (EDT) To: "Tuttle, Gene" Cc: "'pgsql-admin@postgresql.org'" Subject: Re: PL/pgSQL In-reply-to: <199F7F755B80D511877100B0D0F0B76CC3FDE7@mail.rottlundhomes.com> References: <199F7F755B80D511877100B0D0F0B76CC3FDE7@mail.rottlundhomes.com> Comments: In-reply-to "Tuttle, Gene" message dated "Wed, 30 Jun 2004 08:58:57 -0500" Date: Wed, 30 Jun 2004 12:03:58 -0400 Message-ID: <9666.1088611438@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/399 X-Sequence-Number: 14059 "Tuttle, Gene" writes: > I am not able to run any user created functions. > [ plpgsql dumps core ] My bet would be that you have a plpgsql.so library that is mismatched with your postgres server. It's fairly easy to get into such situations if you've upgraded your PG version, or made a custom PG installation without being careful to get rid of the one that comes preinstalled. You didn't give enough details to say exactly what to do to fix it, though. regards, tom lane