Re: Compatible Dumps - Mailing list pgsql-general

From Jake Stride
Subject Re: Compatible Dumps
Date
Msg-id 422718FF.9040104@users.sourceforge.net
Whole thread Raw
In response to Re: Compatible Dumps  (Richard Huxton <dev@archonet.com>)
Responses Re: Compatible Dumps
List pgsql-general
Richard Huxton wrote:

> Jake Stride wrote:
>
>> Is there a way to make a postgresql 8 database dump work with 7.4?
>> I.E I want to do a dump from 8.0 on one machine and put it into a
>> database running on 7.4 on another?
>
>
> Haven't tried this yet, but apart from turning off dollar-quoting for
> functions, it should just work. If you want to test it, try a
> schema-only dump+restore first.
>
That helps a bit, but I still have the following issue:

ERROR:  function pg_catalog.pg_get_serial_sequence("unknown", "unknown")
does not exist

Any ideas how to get around this?

Thanks

Jake

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Does IMMUTABLE have any effect on functions?
Next
From: Richard Huxton
Date:
Subject: Re: Compatible Dumps