Re: versions

"Al Bean" <albean84(at)hotmail(dot)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