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).