Re: Restore from pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Buorn, Yoway" <Yoway(dot)Buorn(at)gd-ais(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore from pg_dumpall
Date: 2005-08-06 04:23:42
Message-ID: 15188.1123302222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Buorn, Yoway" <Yoway(dot)Buorn(at)gd-ais(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message wisan watcharinporn 2005-08-06 05:00:51 how to use column name with Case-sensitive with out usig ""
Previous Message Jeff Frost 2005-08-06 02:07:23 Re: Restore from pg_dumpall