Steve T <steve(at)retsol(dot)co(dot)uk> writes:
> PS Is there a reason that PostgreSql doesn't automatically create the
> foreign key indexes?
Sometimes you don't need/want them, or they might already exist because
of other constraints you made. It is a bit of a gotcha for newbies,
but we've concluded that forcing such indexes to be made would be a
net loss.
regards, tom lane