implementation of a many-to-many relationship

Hi,

I need to implement a many-to-many relationship in PostgreSQL but don't know how
to. I've trawled through the mailing lists but can't find anything, it's very
easy to do in Access so it can't be that hard in PostgreSQL.

I created a linking table between two tables (voter, candidates) called
c_voting, I then reference the two table's primary keys to create a composite
primary key for c_voting.

However when I go to input data into c_voting I get a referential integrity
error saying that the primary key of table voter doesn't match primary key of
c_voting (which it shouldn't).

I've tried everything I can think of for the last four days, but to no avail.

This is a central part of my thesis and I need to get it working as soon as
possible.

If anyone knows how to implement this I would be very very very grateful, I've
read all the documentation I can find but it didn't help.

Many thanks in advance for any advice that you can offer.

>From

Shane.

here are the tables involved.

CREATE TABLE voter (
v_number integer NOT NULL
PRIMARY KEY,

v_name varchar(20),
v_surname varchar(20),
v_birth date,
v_address varchar(50),
v_marital varchar(10),
v_job varchar(15)
);

CREATE TABLE candidates (
c_number integer NOT NULL
PRIMARY KEY,

c_name varchar(20),
c_surname varchar(20),
c_party varchar(20),
c_constituency varchar(35)
);

CREATE TABLE c_voting (
v_number integer NOT NULL
CONSTRAINT cvote_ref_voter
REFERENCES voter
ON UPDATE CASCADE
ON DELETE CASCADE
DEFERRABLE
INITIALLY DEFERRED,

c_number integer NOT NULL
CONSTRAINT cvote_ref_can
REFERENCES candidates
ON UPDATE CASCADE
ON DELETE CASCADE
DEFERRABLE
INITIALLY DEFERRED

-- I tried these variations below but still got nothing working

--primary key(v_number, c_number)

--foreign key (v_number) references voter (v_number),
--foreign key (c_number) references candidates(c_number)
);