Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Dump/Transfer S...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 15233 of 17598
Post > Topic >>

Dump/Transfer Sequence Problems

by stefan.schwarzer@[EMAIL PROTECTED] (Stefan Schwarzer) Apr 9, 2008 at 04:41 PM

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


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 6 Posts in Topic:
Dump/Transfer Sequence Problems
stefan.schwarzer@[EMAIL P  2008-04-09 16:41:25 
Re: Dump/Transfer Sequence Problems
dev@[EMAIL PROTECTED] (R  2008-04-09 16:44:47 
Re: Dump/Transfer Sequence Problems
stefan.schwarzer@[EMAIL P  2008-04-10 13:11:06 
Re: Dump/Transfer Sequence Problems
dev@[EMAIL PROTECTED] (R  2008-04-14 09:33:40 
Re: Dump/Transfer Sequence Problems
stefan.schwarzer@[EMAIL P  2008-04-14 14:25:01 
Re: Dump/Transfer Sequence Problems
dev@[EMAIL PROTECTED] (R  2008-04-14 14:09:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:30:10 CST 2008.