"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