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

appears twice in primary key constraint

From: Victor Pérez Juárez <victor(dot)perez(at)e-evolution(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: appears twice in primary key constraint
Date: 2006-01-06 02:43:49
Message-ID: 43BDD965.1020008@e-evolution.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
    at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
    at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
    at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
    at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
    at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:278)
    at 
net.sourceforge.squirrel_sql.plugins.dbcopy.util.DBUtil.executeUpdate(DBUtil.java:257)
    at 
net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor.createTable(CopyExecutor.java:688)
    at 
net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor._execute(CopyExecutor.java:160)
    at 
net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor.access$000(CopyExecutor.java:57)
    at 
net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor$1.run(CopyExecutor.java:120)
    at java.lang.Thread.run(Thread.java:595)

What is the problem?

Victor Perez
CEO
www.e-evolution.com
victor(dot)perez(at)e-evolution(dot)com

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2006-01-06 11:40:59
Subject: Re: appears twice in primary key constraint
Previous:From: hpb@htl-steyr.ac.atDate: 2006-01-06 01:50:52
Subject: Re: bug in getTime after insertRow with postgresql-8.1-404.jdbc3.jar

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