Skip site navigation (1) Skip section navigation (2)

Setting sequence ids after importing data

From: "Hari Patel" <hariwise(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Setting sequence ids after importing data
Date: 2006-05-09 00:43:08
Message-ID: 77a93e850605081743k284b71bby622c2e84918e265d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi:

I am importing data from sqlite db into postgres. The tables have an id
column that is obtained from a sequence.

To preserve the foreign key relationships, I need to preserve the ids while
importing into postgres.

The problem is that after import, the sequences don't get incremented which
leads to unique constraint violation errors further down.
How do I fix this ?

Thanks,
Hari

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-05-09 01:13:38
Subject: Re: Setting sequence ids after importing data
Previous:From: John PurserDate: 2006-05-08 23:57:46
Subject: Re: Command line option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group