8.2.6 -> 8.1.11: syntax error at or near "OWNED BY" - Mailing list pgsql-general

From Alexander Farber
Subject 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"
Date
Msg-id 943abd910812100541m1ffedbd2wc10da49fa7ce19b@mail.gmail.com
Whole thread Raw
Responses Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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:

CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:denkwerk.sql:1156: ERROR:  syntax error at or near "OWNED" at character 38
psql:denkwerk.sql:1156: LINE 1: ALTER SEQUENCE resource_types_id_seq
OWNED BY resource_types...
psql:denkwerk.sql:1156:                                              ^
 setval
--------
      4
(1 row)

The corresponding spot in the dump file is:

CREATE TABLE resource_types (
    id integer NOT NULL,
    name character varying(60)
);
ALTER TABLE public.resource_types OWNER TO denkwerk;
CREATE SEQUENCE resource_types_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;
ALTER TABLE public.resource_types_id_seq OWNER TO denkwerk;
ALTER SEQUENCE resource_types_id_seq OWNED BY resource_types.id; --line 1156

Does anybody please know what's wrong here
(some new syntax introduced in 8.2.x)?
And what could I do to workaround it
(I have to use CentOS and would like to use its native PostgreSQL 8.1)

Thank you for any hints
Alex

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: c function - undefined symbols
Next
From: "Scott Marlowe"
Date:
Subject: Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY"