On Tue, 08 May 2007 12:48:30 +0100
Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> You can do that, but you'll lose the enforcement of referential
> integrity, which is what foreign keys give you.
If I get you right:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?
Felix
---------------------------(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
