On Wed, Sep 15, 2010 at 03:16:55PM +0000, Gissur Þórhallsson wrote:
> Hi there,
>
> I have a somewhat peculiar problem.
>
> To begin with, here are links to my schema and rules: my_table and
> associated rules <http://postgresql.pastebin.com/0eCSuvkU> and
> my_table_history <http://postgresql.pastebin.com/cGm617Cp>
> [etc.]
> Does anybody have any idea what is going on?
Yes. You're using RULEs where TRIGGERs would do. Change to TRIGGERs.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate