On Tue, Aug 02, 2005 at 10:01:50AM -0500, Dan Armbrust wrote: > I shouldn't have to manually run Analyze to make the DB be capable of > handling inserts involving tables with foreign keys correctly. My code > that is doing the inserts is a java application that works across > multiple DBS - MySQL, PostgreSQL, DB2, MS Access, Sybase, etc. [etc, rant removed] You don't _have_ to be rude. This is a known limitation, and people have suggested the usual workarounds. This is an open source project -- if you think you can make it better, please by all means post a patch. HAND. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "El sentido de las cosas no viene de las cosas, sino de las inteligencias que las aplican a sus problemas diarios en busca del progreso." (Ernesto Hernández-Novich) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly