A couple of pgsql questions

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

Responses

Browse pgsql-general by date

  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