Re: versions - Mailing list pgsql-general

From Tom Lane
Subject Re: versions
Date
Msg-id 21048.1038424896@sss.pgh.pa.us
Whole thread Raw
In response to versions  ("Al Bean" <albean84@hotmail.com>)
List pgsql-general
"Al Bean" <albean84@hotmail.com> writes:

> mytestdb-# select current_timestamp;
> ERROR:  parser: parse error at or near "select"

That command by itself should be fine.  I suspect you had something left
over in psql's command buffer from an incomplete previous command
(forgot the semicolon maybe?)

> mytestdb=# create function test1() returns integer as 'begin return 1; end;'
> language 'plpgsql';
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.

You didn't install plpgsql (see createlang script).

            regards, tom lane

pgsql-general by date:

Previous
From: Medi Montaseri
Date:
Subject: How was my PG compiled
Next
From: Tom Lane
Date:
Subject: Re: How was my PG compiled