Re: update problem in partitioned tables

Thanks. Check this website that talk abt the approach that I had mentioned
http://blogs.ittoolbox.com//oracle/guide/archives/comparing-partitioned-tables-in-oracle-and-enterprisedbpostgresql-13261

I also tried your method (triggers on the child table) and it gives the same
error too.

Josh

On 9/12/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Josh Harrison" <joshques(at)gmail(dot)com> writes:
> > Now I create this function to redirect the inserts and updates on the
> > master table.
>
> Uh ... there never will be any updates in the master table, since it
> hasn't got any entries.
>
> What you'd need is an insert trigger on the master and update triggers
> on each child table. I think the logic of this trigger is wrong for
> the update case anyway.
>
> regards, tom lane
>