Re: [GENERAL] Strange invalid constrain problem with PostgreSQL 8.3.1

2009-01-14 Thread Richard Huxton
ries van Twisk wrote: > hey All, > > (Resend from novice) > > I if a problem that apparently I can insert a record into my table with > a constrain while in fact the reference doesn't exist: Well, a test case is what's really needed, but while you're busy with that the obvious points are: 1. Yo

[GENERAL] Strange invalid constrain problem with PostgreSQL 8.3.1

2009-01-14 Thread ries van Twisk
hey All, (Resend from novice) I if a problem that apparently I can insert a record into my table with a constrain while in fact the reference doesn't exist: On the table acc_ops.tbl_part_status I have the following constrain added: CONSTRAINT fk_tbl_part_status_2 FOREIGN KEY (part_num)