"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes:
> On 8/13/07, Hyatt, Gordon <Gordon.Hyatt@xxxxxxxxxxxxxxxxxx> 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
