Problem with 6.5 reload

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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Responses

Browse pgsql-general by date

  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)