Re: [SQL] constrains problem...

2005-12-07 Thread Richard Huxton
Jure Kodzoman wrote: What i would like to do is create a trigger or a constraint which would on delete of an entry from table1 also deleted all entries containing code from table1 in table_rel. When i try to put a constraint via PgAdmin3 it says it can't do it because 't1code' is not primary ke

[SQL] constrains problem...

2005-12-07 Thread Jure Kodzoman
Hy list, i would like to ask you for help. I have 3 tables. table1 has primary key 't1code' and table_rel is 'many to many' relation for table2. table2 primary key is 't2code' table_rel has two fields: 't1code' and 't2code', where both of them together make a primary key for the rela