[Monetdb-developers] Constraint violations with all details

Romulo Goncalves R.A.Goncalves at cwi.nl
Sun Nov 23 15:18:00 CET 2008

Something like this might work...

Select to_way from relation_members_way where to_way not in (select 
to_way from ways);


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
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

More information about the developers-list mailing list