Problem with 6.5 reload
Glen and Rosanne Eustace <agree@godzone.net.nz>
From: AGRE Enterprises Limited <agree@godzone.net.nz>
To: pgsql-general@postgresql.org
Date: 1999-04-10T05:18:48Z
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@godzone.net.nz, ICQ: 10397208 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=