Currently I have a table on Microsoft Sequel Server that I wish to port over
to Postgresql. This table has four primary keys and it's the combination
of the four fields that make the record unique. I have created the table in
Postgresql using this in my create.
CONSTRAINT "attachments_pkey" PRIMARY KEY
The table gets created with four primary keys, but when I copy in the data I
get the following error..
"Cannot insert a duplicate key into unique index attachments_pkey"
Senior Business Systems Analyst
Bristol Aerospace Ltd.
(204) 775-8331 3402
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2002-04-18 15:35:02|
|Subject: Re: Multiple Primary Keys|
|Previous:||From: April L||Date: 2002-04-18 14:48:53|
|Subject: Indexes: which to use BTREE RTREE HASH GIST?|