Re: value

From: David Fetter <david(at)fetter(dot)org>
To: Gissur Þórhallsson <gissur(at)loftmyndir(dot)is>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: value
Date: 2010-09-15 16:07:44
Message-ID: 20100915160744.GA12946@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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

In response to

  • value at 2010-09-15 15:16:55 from Gissur Þórhallsson

Responses

  • Re: value at 2010-09-16 12:47:17 from Gissur Þórhallsson

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-15 16:22:15 Re: help with error "unexpected pageaddr"
Previous Message Carlos Mennens 2010-09-15 16:05:25 Re: Table Comments