Re: inherited table and rules

On Tue, 22 Mar 2005, Scott Frankel wrote:

>
> This is weird. I have two tables: one inherits from the other. And I
> have a
> rule that populates the inherited table with changes from the first.
> When I
> update a row in the first table, I get an ever-larger number of rows
> added to
> both it and the inherited table. i.e.:
>
> update 1 yields 2 new rows
> update 2 yields 6 new rows
> update 3 yields 42 new rows
> update 4 yields 1806 new rows
>
> I'm clearly doing something wrong ;)

I think you need to be using ONLY (or changing the sql_inheritance GUC
variable) in all the queries on people in order to not also be getting
rows from people_history in the SELECT and UPDATE (and in fact changing
the select and update statements to FROM ONLY people seems to work for
me).