Restore from pg_dumpall

From: "Buorn, Yoway" <Yoway(dot)Buorn(at)gd-ais(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Restore from pg_dumpall
Date: 2005-08-05 23:59:12
Message-ID: 21A801CCBAC79545878E3C1137912E41FBF37E@CAMV02-MAIL01.ad.gd-ais.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-08-06 02:07:23 Re: Restore from pg_dumpall
Previous Message Stephan Szabo 2005-08-05 22:00:24 Re: outer joins