Steve T <steve@retsol.co.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
