From: | "Al Bean" <albean84(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | versions |
Date: | 2002-11-27 17:58:28 |
Message-ID: | F80p48RpaswtSPF6fxv0002c4d4@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I just compiled and installed postgresql.
I found a webpage that showed a few steps to test the installation but it
was for 7.0.something.
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 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 version?
Thanks,
-Al
.
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-11-27 18:01:13 | Re: Delete Order When Referential Integrity Is Active |
Previous Message | Ron St.Pierre | 2002-11-27 17:55:16 | Re: Select nextval problem |