"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On 8/13/07, Hyatt, Gordon <[EMAIL PROTECTED]> wrote: >> When I attempt to run insert_a_and_b, insert_b fails with a foreign key >> violation.
> I ran your exact same code and it worked fine. Note that I changed one line: Works for me too (with Scott's correction), in 8.1.x, 8.2.x, and HEAD. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match