Re: Rule appears not to fire on insert w/ "except"

Chris Kratz <chris(dot)kratz(at)vistashare(dot)com> writes:

> Hello All,
>
> We have finally tracked down a bug in our application to a rewrite rule on a
> table. In essence, the rewrite rule in question logs any inserts to another
> table. This works correctly in all cases except where an "except" clause is
> used in the insert statement. In this case, the rows are inserted into the
> primary table as expected, but the rule either does not fire, or fires in
> such a way that nothing is placed in the changes table.

You must be referring to something like;

insert into foo
select *
from sometable
except
select *
from someothertable
;

If there's an EXCEPT clause on INSERT, I've never seen it.

Perhaps you should post your insert query and your rule declaration.

> As a side note, is there a way to see the final sql after all "rewrite" rules
> have been processed? It might help us understand what is going on.

Not SQL but see config setting;

debug_print_rewritten

--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/