Jonathan Knopp <[EMAIL PROTECTED]> writes: > I'm trying to set up some complex rules and having a hard time figuring > out why they won't work. Being able to see the query after all the rules > have been applied would be a huge help, but I can't seem to find a way > to do this. log_statement only shows the original. debug_print_rewritten > works, but displays it in such a way as to be virtually unusable.
Sorry, but that's all there is. The rewriter isn't a source-to-source transformation. (If you feel like hacking, it might be interesting to try applying the ruleutils.c functions to the rewritten querytree, but I'm quite unsure how readable the result will be.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly