Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"

On Wed, Dec 10, 2008 at 6:41 AM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)com> wrote:
> Hello,
>
> I've pg_dump'ed a database from PostgreSQL 8.2.6 / openSUSE 10.3
> and now trying to load it as a "postgres" user at 8.1.1 / CentOS 5.2
> and get numerous errors like:

That's not directly supported. The other direction is. You could try
dumpig the 8.2 database with the 8.1 dump, but it's not guaranteed to
work either.

> Does anybody please know what's wrong here
> (some new syntax introduced in 8.2.x)?

Yep.

> And what could I do to workaround it
> (I have to use CentOS and would like to use its native PostgreSQL 8.1)

Create the same basic thing by hand in 8.1 and dump it and see what
the syntax looks like. Now write a script to transform your 8.2 dump
into that format.

OR upgrade your 8.1 machine to 8.2