2009/6/11 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> Referenced by:
> "test2_y_fkey" IN test2 FOREIGN KEY (y) REFERENCES test1(a)
>
> Is there a magic reason why the IN is capitalized? (Maybe "from" would be
> better anyway?)
Isn't "on" the conventional preposition to use here? I would think of
this as a foreign key "on" test2, referencing test1.
In the same way you would talk about having a primary key "on" a
table. Same goes for indexes, triggers, table constraints, etc. IMO
Cheers,
BJ