Re: appears twice in primary key constraint - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: appears twice in primary key constraint
Date
Msg-id 43BE574B.9060505@opencloud.com
Whole thread Raw
In response to appears twice in primary key constraint  (Victor Pérez Juárez <victor.perez@e-evolution.com>)
List 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

pgsql-jdbc by date:

Previous
From: Victor Pérez Juárez
Date:
Subject: appears twice in primary key constraint
Next
From: Kyle R Morse/Eden
Date:
Subject: Re: Out Parameter Support