Dump/Transfer Sequence Problems - Mailing list pgsql-general

From Stefan Schwarzer
Subject Dump/Transfer Sequence Problems
Date
Msg-id ECA59A13-95E5-489A-84CE-BF06F4206608@grid.unep.ch
Whole thread Raw
Responses Re: Dump/Transfer Sequence Problems  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi,

I am using Navicat to transfer data from one database to another. But
it soon gives me an error message like the following:

[Err] [Dtf] Transfer Data [create table "admin"."news" (   "id" int4
not null default nextval('news_id_seq1'::regclass) , "date" date ,
"text_en" text , "text_fr" text , "text_es" text )  WITHOUT OIDS;
ALTER table "admin"."news" SET WITHOUT CLUSTER;;]: ERROR:  relation
"news_id_seq1" does not exist

Ok, I understand meanwhile that there is a sequence being created when
using SERIALs.... But why does a dump or that kind of transfer
transfers not the sequence with it? Or is it because I am using 8.1 on
one and 8.2 on another machine? I can't imagine...

Thanks for any suggestions,

Stef


pgsql-general by date:

Previous
From: Syra.Didelez@agfa.com
Date:
Subject: Re: Problem with windows Postgres 8.3.1 MSI binary distribution
Next
From: Maxim Boguk
Date:
Subject: Postgresql 8.3: stats collector process eat all CPU all time