From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Dump/Transfer Sequence Problems |
Date: | 2008-04-09 14:41:25 |
Message-ID: | ECA59A13-95E5-489A-84CE-BF06F4206608@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wollny | 2008-04-09 14:42:18 | Re: tsvector_update_trigger throws error "column is not of tsvector type" |
Previous Message | Peter Geoghegan | 2008-04-09 14:34:31 | Problem with windows Postgres 8.3.1 MSI binary distribution |