"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