Stephan! > This is a known issue with the unique constraint.
Ok. Do you know any plans on this issue fix? > > --case 2 prepare > > --case 3 prepare > > I seem to get foreign key violations on both of these on both 7.4.x and > 8.0 cvs using the scripts you provided just by running them in psql. I > think you need to give more details about what you were trying. Hmmm.... In the nearest couple of days i'll be able to check this under linux psql 8 beta 2 but under windows it is a repeatable. What is your target platform? *nix? ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match