Re: Foreign key reference to a view column

"GFC" <gfc.news.invalid_at_web2news.net> wrote in message news:28745N450_at_web2news.com...
> Hello,
>
> Can someone help me with the following:
>
> I recently had to modify a customer table by adding a version column
> next to each customer number. This to allow tracking changes of customer
> information.
>
> Other tables refered to the original customer table with a foreign key
> reference on the customer number.
>
> The problem is that the original foreign key constraint cannot be used
> on the view so my application can't validate customer numbers anymore.
>
> How can I simulate a foreign key referencing a view column?
>
> Has anyone encountered a similar problem?
>
> Thanks,
>
> Gian Franco
> --
> Direct access to this group with http://web2news.com
> http://web2news.com/?comp.databases.oracle.misc

1 By means of a before insert for each row trigger. Shouldn't be a problem. You don't mention your version (Yes, I know typing those 5 characters is extreemly difficult), and IIRC this behavior has changed in 9i (and 8i is desupped at the end of this year anyway)

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address