versions
Hi,
I just compiled and installed the latest version of postgresql.
I found a webpage that showed a few steps to test the installation but it
was for 7.0.something but i could not find anything for the latest version
so i tried it anyway.
I was able to create a db but there were two things that I could not do:
mytestdb-# select current_timestamp;
ERROR: parser: parse error at or near "select"
and
mytestdb=# create function test1() returns integer as 'begin return 1; end;'
language 'plpgsql';
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Pre-installed languages are SQL, C, and internal.
Additional languages may be installed using 'createlang'.
Now I noticed that I could get the first test case working if i used all
caps for SELECT. Is postgresql case sensitive? is there a way to compile
it so that it is not case sensitive? or can I not get this working because
I'm using different (newer) version?
Thanks,
-Al
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
Al Bean wrote:
mytestdb-# select current_timestamp;
ERROR: parser: parse error at or near "select"
Are you sure? Try it again. I think you made a typo the first time. SQL
is not case sensitive (at least not in this case). "select
current_timestamp;" works fine for me.
mytestdb=# create function test1() returns integer as 'begin return 1;
end;' language 'plpgsql';
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Pre-installed languages are SQL, C, and internal.
Additional languages may be installed using 'createlang'.
The error message is self-explanatory.
use from the command line:
# createlang plpgsql mytestdb
Jc
"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
Thanks guys,
I got it working now.
Tom: you were correct about the command buffer. As I recall the first time
I typed in that statment it was w/o a semicolon. (Thanks for the tip about
the buffer, I'm new to postres.)
One last question:
I still have to poke around the internet some more but what are the best GUI
admins for postgres. I saw one that required M$ Windows but I would like
one for Linux.
Thanks again,
Al
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
Import Notes
Resolved by subject fallback