From: | "Alexander Farber" <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY" |
Date: | 2008-12-10 13:41:30 |
Message-ID: | 943abd910812100541m1ffedbd2wc10da49fa7ce19b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-12-10 13:51:29 | Re: 8.2.6 -> 8.1.11: syntax error at or near "OWNED BY" |
Previous Message | Albe Laurenz | 2008-12-10 13:39:46 | Re: c function - undefined symbols |