Re: update problem in partitioned tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Harrison" <joshques(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: update problem in partitioned tables
Date: 2007-09-12 16:03:51
Message-ID: 23289.1189613031@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-09-12 16:28:41 Re: problems with large table
Previous Message Mike Charnoky 2007-09-12 15:42:20 problems with large table