Restore from pg_dumpall - Mailing list pgsql-admin

From Buorn, Yoway
Subject Restore from pg_dumpall
Date
Msg-id 21A801CCBAC79545878E3C1137912E41FBF37E@CAMV02-MAIL01.ad.gd-ais.com
Whole thread Raw
Responses Re: Restore from pg_dumpall  (Jeff Frost <jeff@frostconsultingllc.com>)
Re: Restore from pg_dumpall  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: outer joins
Next
From: Jeff Frost
Date:
Subject: Re: Restore from pg_dumpall