X-Original-To: pgsql-sql@postgresql.org
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id E70974763A2
	for <pgsql-sql@postgresql.org>; Fri, 14 Mar 2003 10:05:26 -0500 (EST)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Fri Mar 14 16:05:30 2003 +0100
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA03064; Fri, 14 Mar 2003 16:05:30 +0100 (MET)
Message-ID: <3E71EFB9.CD27D06B@rodos.fzk.de>
Date: Fri, 14 Mar 2003 16:05:29 +0100
From: Christoph Haller <ch@rodos.fzk.de>
X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Cc: susan@hexworx.com
Subject: Re: Create function statement with insert statement
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200303/363
X-Sequence-Number: 12402

>
> Hi Chris,
>
> Thanks for your efforts but seems like something very odd is going on
> because even though I commented out the constraints I still received
the
> parse errors.
>
> I searched the archives but looked for references to triggers and
functions
> rather than parse errors.
>
> Regards
>
Susan,

Could you check if the SQL procedural language is available at all by

select * from pg_language ;
 lanname  | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
----------+---------+--------------+---------------+--------------+--------

 sql      | f       | t            |             0 |         2248 | {=U}

 internal | f       | f            |             0 |         2246 | {=}
 c        | f       | f            |             0 |         2247 | {=}
(3 rows)

These three should show up by default; Maybe somebody dropped it
accidentally.

Regards, Christoph