Re: Restore from pg_dumpall - Mailing list pgsql-admin

From Tom Lane
Subject Re: Restore from pg_dumpall
Date
Msg-id 15188.1123302222@sss.pgh.pa.us
Whole thread Raw
In response to Restore from pg_dumpall  ("Buorn, Yoway" <Yoway.Buorn@gd-ais.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Restore from pg_dumpall
Next
From: "wisan watcharinporn"
Date:
Subject: how to use column name with Case-sensitive with out usig ""