Re: INSERT RULE QUERY ORDER - Mailing list pgsql-general

From Tom Lane
Subject Re: INSERT RULE QUERY ORDER
Date
Msg-id 11756.1060110807@sss.pgh.pa.us
Whole thread Raw
In response to INSERT RULE QUERY ORDER  (Justin Tocci <jtocci@tlcusa.com>)
List pgsql-general
Justin Tocci <jtocci@tlcusa.com> writes:
> When my RULE takes the form of:
> CREATE RULE name AS ON INSERT TO table DO INSTEAD ( UPDATE query ; INSERT
> query) ;

> The INSERT query doesn't fire and there is no error.

What do you mean by "doesn't fire"?  I think you'd better provide a
complete example of what you're doing.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: indices and cidr/inet type
Next
From: "scott.marlowe"
Date:
Subject: Re: multiple insert into's (may be NEWBIE question)