Problem with 6.5 reload - Mailing list pgsql-general

From AGRE Enterprises Limited
Subject Problem with 6.5 reload
Date
Msg-id 199904100518.RAA09296@agree-2.godzone.net.nz
Whole thread Raw
Responses RE: [GENERAL] Problem with 6.5 reload  (Glen and Rosanne Eustace <agree@godzone.net.nz>)
List 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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

pgsql-general by date:

Previous
From: Aaron Holtz
Date:
Subject: Inet and distinct bug or is it me? (v 6.5beta1)
Next
From: "Patrick Welche"
Date:
Subject: insert iff !exist