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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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