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

From Tom Lane
Subject Re: update problem in partitioned tables
Date
Msg-id 23289.1189613031@sss.pgh.pa.us
Whole thread Raw
In response to update problem in partitioned tables  ("Josh Harrison" <joshques@gmail.com>)
Responses Re: update problem in partitioned tables  ("Josh Harrison" <joshques@gmail.com>)
List pgsql-general
"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: "Josh Harrison"
Date:
Subject: update problem in partitioned tables
Next
From: Mike Charnoky
Date:
Subject: problems with large table