Hello all,
i have a view defined as a simple select of a table. This table is inherited by a couple of others. All entries belong to the child-tables.
I also have an unconditional update rule on the view. If i do an update to the view, the update is rewritten to update the father-table.
And now a strange thing is happening: If i do an update, this update is done correctly only on the first defined child-table. If it applies to one of the other 8 child-tables nothing happens at all.
If i update the father-table directly everything is working like expected (the update is "directed" to the right table).
Is this a known limitation with views, rules and inherited tables i haven't heard of? Or is it a bug?
My Postgres is version 7.4.5.
Thanks in advance
Sebastian
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
