I'm upgrading Gforge and the first sql file I tried to load gave me the following error:

--
-- Function to enforce consistency in task start/end dates
--
DROP FUNCTION projtask_insert_depend () CASCADE ;
ERROR: parser: parse error at or near "CASCADE"
....

Can anyone point out to me what is wrong with this sql? Thanks.


Yoway Buorn
Software Engineer
Imagery Systems Engineering

GENERAL DYNAMICS
Advanced Information Systems

"Cockfighting has always been my idea of a great sport- two armed entrées battling to see who'll be dinner." -- P.J. O'Rourke

Yoway,

What are you upgrading from/to? Can you share your dump and restore command
line as well?

On Fri, 5 Aug 2005, Buorn, Yoway wrote:

> I'm upgrading Gforge and the first sql file I tried to load gave me the following error:

--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"Buorn, Yoway" <Yoway.Buorn@gd-ais.com> writes:
> I'm upgrading Gforge and the first sql file I tried to load gave me the =
> following error:

> DROP FUNCTION projtask_insert_depend () CASCADE ;
> ERROR: parser: parse error at or near "CASCADE"

> Can anyone point out to me what is wrong with this sql? Thanks.

Nothing ... in any PG version newer than 7.3 or so. Are you trying
to back-port a dump into an older server version, and if so why?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org