| 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: | Whole Thread | Raw Message | 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) |