diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-10-19 19:00:47 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-10-19 19:00:47 +0000 |
commit | c1f91a38e20864c14650794a64d52f2d6c900e0f (patch) | |
tree | 49580b7e35a35799b5abfbeb0d3de03eab754744 /doc/src | |
parent | 757b98fda828275443dfdf6e220001c9d497133a (diff) | |
download | postgresql-c1f91a38e20864c14650794a64d52f2d6c900e0f.tar.gz postgresql-c1f91a38e20864c14650794a64d52f2d6c900e0f.zip |
Fix rewrite code so that rules are in fact executed in order by name,
rather than being reordered according to INSTEAD attribute for
implementation convenience.
Also, increase compiled-in recursion depth limit from 10 to 100 rewrite
cycles. 10 seems pretty marginal for situations where multiple rules
exist for the same query. There was a complaint about this recently,
so I'm going to bump it up. (Perhaps we should make the limit a GUC
parameter, but that's too close to being a new feature to do in beta.)
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/rules.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml index 50bcf3a4538..4b72d5de3b2 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/rules.sgml,v 1.25 2002/10/14 22:14:34 tgl Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/rules.sgml,v 1.26 2002/10/19 19:00:47 tgl Exp $ --> <Chapter Id="rules"> <Title>The Rule System</Title> @@ -1043,8 +1043,8 @@ CREATE RULE rule_name AS ON event in more or less parse trees. So the parse trees in the rule actions must have either another command type or another result relation. Otherwise this recursive process will end up in a loop. - There is a compiled in recursion limit of currently 10 iterations. - If after 10 iterations there are still update rules to apply the + There is a compiled-in recursion limit of currently 100 iterations. + If after 100 iterations there are still update rules to apply the rule system assumes a loop over multiple rule definitions and reports an error. </Para> |