Something like this might work... Select to_way from relation_members_way where to_way not in (select to_way from ways);
Romulo Stefan de Konink wrote: > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
