Hi,
I cannot find it back in the trackers but I think it have asked this question before. Would it be possible to output the actual failing constraint details instead of 'just an error'. sql>alter table relation_members_way add constraint relation_to_way_fkey foreign key(to_way) references ways; !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'relation_members_way.relation_to_way_fkey' violated Inserting with INSERTS will give a nice error, because the query it self contains the problem. This is not true for a copy into, or in this respect just an alter table. Stefan ps. indeed I have to think too long about a query that will show me the non existing primary keys. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
