Re: [BUGS] INSERT .. SELECT should redo SELECT if a duplicate key is found

ferential integrity violation - key in teste still referenced from teste teste=# commit; COMMIT So, the problem is probably with the subselects. I wonder if UPDATE has the same problem. -- Cesar Eduardo Barros ElNet Hightech -- Administrador de Sistemas Unix [EMAIL PROTECTE

[BUGS] INSERT .. SELECT should redo SELECT if a duplicate key is found

says nothing about INSERT. My opinion is that INSERT should also reevaluate the WHERE condition. -- Cesar Eduardo Barros ElNet Hightech -- Administrador de Sistemas Unix [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists

[BUGS] Move constant evaluation to inside IN subselect

ht be another bug. The planner should convert _non-null constant_ IN (SELECT _non-aggregate_ FROM ... WHERE ...) into EXISTS (SELECT 1 FROM ... WHERE (...) AND _non-aggregate_ = _non-null constant_) -- Cesar Eduardo Barros ElNet Hightech -- Administrador de Sistemas Unix [EMAIL PROTECTED] ---