X-Original-To: pgsql-sql@postgresql.org Received: from sydney1.qnix.com.au (unknown [203.98.67.20]) by postgresql.org (Postfix) with ESMTP id AB94147590C for ; Fri, 14 Mar 2003 13:58:42 -0500 (EST) Received: from oemcomputer (dialup-132.39.194.203.acc02-stge-pth.comindico.com.au [203.194.39.132]) (authenticated) by sydney1.qnix.com.au (8.11.6/8.11.6) with ESMTP id h2EJ5QQ15412; Sat, 15 Mar 2003 06:05:27 +1100 Message-ID: <002b01c2ea5b$b0e95380$1f84fea9@oemcomputer> Reply-To: "Susan Hoddinott" From: "Susan Hoddinott" To: "Christoph Haller" Cc: References: <3E71EFB9.CD27D06B@rodos.fzk.de> Subject: Re: Create function statement with insert statement Date: Sat, 15 Mar 2003 02:58:22 +0800 Organization: Hexworx MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200303/371 X-Sequence-Number: 12410 Yes. I can select from this table although the output is slightly different: lanname | lanispl | lanpltrusted | lanplcallfoid | lancompiler ----------+---------+--------------+---------------+------------- internal | f | f | 0 | n/a C | f | f | 0 | /bin/cc sql | f | f | 0 | postgres (3 rows) Regards ----- Original Message ----- From: "Christoph Haller" To: Cc: Sent: Friday, March 14, 2003 11:05 PM Subject: Re: [SQL] Create function statement with insert statement > > > > 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 >