Home Forums Programming General how to index partitioning views and create triggers on them RE: how to index partitioning views and create triggers on them

  • i have created a partitioned view as

    create view a

    as

    select * from tbl1

    union all

    select * from tbl2

     

    and tbl1 and tbl2 have the same structure and primary keys are defined on them and we have a chek constraint on one of the column which is the part of the primary key.

    after creating the instead of insert,delete and update trigger on the viewand then when i fire the previous queyit gives me an error