From: | AGRE Enterprises Limited <agree(at)godzone(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with 6.5 reload |
Date: | 1999-04-10 05:18:48 |
Message-ID: | 199904100518.RAA09296@agree-2.godzone.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have just started to experiment with the new 6.5 beta.
When trying to reload the databases I got an error on what is a pretty
simple SQL command.
The pg_dump was from 6.3.1
I did psql < db.out
The error is
CREATE FUNCTION next_target ( )
RETURNS int4 AS
'update global set next_target=next_target+1;select next_target from global'
LANGUAGE 'SQL';
ERROR: parser: parse error at or near ""
I have tried repeating manually and get the same command.
The help would indicate the syntax is still correct.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace, on behalf of
GodZone Internet Services, a division of AGRE Enterprises Limited
176 Te Awe Awe Street, Palmerston North, New Zealand
Ph: +64 6 356 2562, Fax: +64 6 357 0271
http://www.godzone.net.nz, EMail: agree(at)godzone(dot)net(dot)nz, ICQ: 10397208
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 1999-04-10 15:47:50 | insert iff !exist |
Previous Message | Aaron Holtz | 1999-04-09 19:51:40 | Inet and distinct bug or is it me? (v 6.5beta1) |