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

Re: appears twice in primary key constraint

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Victor Pérez Juárez <victor(dot)perez(at)e-evolution(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: appears twice in primary key constraint
Date: 2006-01-06 11:40:59
Message-ID: 43BE574B.9060505@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Victor Pérez Juárez wrote:
> Hi very body!
> 
> I am execute a dbcopy to migrate from ORacle to PostgreSQL but I get 
> this error when is create prymary key
> 
> org.postgresql.util.PSQLException: ERROR: column "ad_client_id" appears 
> twice in primary key constraint

You should probably ask the authors of dbcopy as this appears to be a 
client/application problem, not a JDBC driver problem -- dbcopy is 
apparently creating a bogus CREATE TABLE / ADD CONSTRAINT query.

-O

In response to

pgsql-jdbc by date

Next:From: Kyle R Morse/EdenDate: 2006-01-06 14:55:50
Subject: Re: Out Parameter Support
Previous:From: Victor Pérez JuárezDate: 2006-01-06 02:43:49
Subject: appears twice in primary key constraint

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