From: | Jack V Chung <flattop(at)MIT(dot)EDU> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | flattop(at)MIT(dot)EDU |
Subject: | A couple of pgsql questions |
Date: | 2000-10-18 16:48:55 |
Message-ID: | 200010181648.MAA14350@nerd-xing.mit.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I want to apologize in advance if I sent this to the wrong mailing list.
I'm was trying out the example functions using TCL, but for function
was not created. Here's the error:
db=# CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS '
if {$1 > $2} {return $1}
return $2
' LANGUAGE 'pltcl';
db'# physionetdb'# physionetdb'# ERROR: Unrecognized language specified in
a CREATE FUNCTION: 'pltcl'. Recognized languages are sql, C, internal
and the created procedural languages.
Here is my current version:
db=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
I used the RPM to installed all the files including
postgresql-tk-7.0.2-2.i386.rp and postgresql-tcl-7.0.2-2.i386.rpm
Can someone assist me?
Another question, can someone point me to documentation that explains how
to wrap a few insert statments in a transaction?
thanks a lot
jack
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Edginton | 2000-10-18 17:35:13 | [HACKERS] pg_connect error |
Previous Message | Peter Eisentraut | 2000-10-18 16:18:07 | Re: OID and joins |