Re: INSERT RULE QUERY ORDER

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