Re: update problem in partitioned tables - Mailing list pgsql-general

From Josh Harrison
Subject Re: update problem in partitioned tables
Date
Msg-id 8d89ea1d0709121005i4bd0e4bex559aa23646af453a@mail.gmail.com
Whole thread Raw
In response to Re: update problem in partitioned tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@sss.pgh.pa.us> wrote:
"Josh Harrison" < joshques@gmail.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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: problems with large table
Next
From: "Jay Dickon Glanville"
Date:
Subject: Re: Event-driven programming?