Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore - Mailing list pgsql-general

From Jim Caley
Subject Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore
Date
Msg-id 3B716641.41AE7B79@chesco.com
Whole thread Raw
In response to Upgrade 7.0.2 -> 7.1.2: Errors during Restore  (Jim Caley <caley@chesco.com>)
List pgsql-general
> Most of those look like you had a "regression" database hanging around
> in your old installation; it's complaining because the CREATE FUNCTION
> commands refer to shared libraries that you evidently don't have around
> any more.

Sure enough, okay I'll drop it.

> > psql:./pgdump.all-just.before.going.to.pgsql-7.1.2:118341: ERROR:  Rule WHERE co
> > ndition may not contain references to other relations
>
> This one *might* be a real problem; you'll need to look at line 118341 of
> your dump file and see if the failed rule is one of yours or not.  Since
> the line number is so close to the others, I suspect it's also an
> artifact of trying to reload the 7.0 regression database.

Yes, this rule is from the regression database.

Many thanks,
Jim

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgrade 7.0.2 -> 7.1.2: Errors during Restore
Next
From: "Brian C. Doyle"
Date:
Subject: First Saturday and Last Saturday of a month