Mallah,
> Is there any way to enforce fkeys only on subset of
> the table something on the lines of unique partial indexes
>
> or any work around ? (on update or insert trigger is the only thing i can
> think of)
so, why don't you ask me these questions? Nu?
If you mean what I believe that yo
On Fri, 6 Jun 2003, Richard Huxton wrote:
> On Thursday 05 Jun 2003 3:55 pm, [EMAIL PROTECTED] wrote:
> > hi ,
> >
> > Is there any way to enforce fkeys only on subset of
> > the table something on the lines of unique partial indexes
>
> I'm afraid not (AFAIK). What might be a solution in your ca
On Thursday 05 Jun 2003 3:55 pm, [EMAIL PROTECTED] wrote:
> hi ,
>
> Is there any way to enforce fkeys only on subset of
> the table something on the lines of unique partial indexes
I'm afraid not (AFAIK). What might be a solution in your case is to define
another unique index. For example, you m
[EMAIL PROTECTED] wrote:
hi ,
Is there any way to enforce fkeys only on subset of
the table something on the lines of unique partial indexes
Sure. Put NULL values into the referencing fields of those rows you
don't want to be checked.
Jan
--
#
On Thu, Jun 05, 2003 at 20:25:32 +0530,
[EMAIL PROTECTED] wrote:
>
>
> hi ,
>
> Is there any way to enforce fkeys only on subset of
> the table something on the lines of unique partial indexes
>
> or any work around ? (on update or insert trigger is the only thing i can think of)
If the fore
hi ,
Is there any way to enforce fkeys only on subset of
the table something on the lines of unique partial indexes
or any work around ? (on update or insert trigger is the only thing i can think of)
regds
mallah.
-
Get your free web based email at tra
