Re: Strange bug

On Tuesday 29 November 2005 15:52, Leif B. Kristensen wrote:
>Uh-oh. That's my first 'gotcha' in PostgreSQL.
>
>I added the following constraints:

I probably should drop both the inheritance and the citation_id 
altogether, and operate with two separate tables:

CREATE TABLE relation_citations (   relation_fk INTEGER REFERENCES relations (relation_id),   source_fk INTEGER
REFERENCESsources (source_id),   CONSTRAINT PRIMARY KEY (relation_fk, source_fk)
 
);

CREATE TABLE event_citations (   event_fk INTEGER REFERENCES events (event_id),   source_fk INTEGER REFERENCES sources
(source_id),  CONSTRAINT PRIMARY KEY (event_fk, source_fk)
 
);

Is there an easy and non-disruptive way to do this?
-- 
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE