Jan Wieck [EMAIL PROTECTED] writes:
Tom Lane wrote:
The problem here is that the query rewriter tries to hang the query's
qualification (WHERE clause) onto the rule's action query, so that
the action query won't be done unless the query finds at least one
row to update.
NOTIFY commands,
Would be something for a STATEMENT trigger. We don't have 'em
yet and I'm not sure what kind of information they will
receive if we finally implement them. But the number of rows
affected by the statement is a good candidate.
That's no help for a 7.1 solution
Bruce Momjian [EMAIL PROTECTED] writes:
OK, added to TODO:
* Allow NOTIFY in rules
Uh, what does that have to do with the problem? It's certainly not
an accurate rendering of either the current or proposed status ...
regards, tom lane
Bruce Momjian [EMAIL PROTECTED] writes:
OK, added to TODO:
* Allow NOTIFY in rules
Uh, what does that have to do with the problem? It's certainly not
an accurate rendering of either the current or proposed status ...
Oops, can you give me a line. What was the issue?
--
Bruce
Bruce Momjian [EMAIL PROTECTED] writes:
OK, added to TODO:
* Allow NOTIFY in rules
Uh, what does that have to do with the problem? It's certainly not
an accurate rendering of either the current or proposed status ...
Oops, can you give me a line. What was the issue?
"Allow NOTIFY in
Bruce Momjian [EMAIL PROTECTED] writes:
OK, added to TODO:
* Allow NOTIFY in rules
Uh, what does that have to do with the problem? It's certainly not
an accurate rendering of either the current or proposed status ...
Oops, can you give me a line. What was the issue?
"Allow
Is there a TODO item here, Tom?
"Steve Howe" [EMAIL PROTECTED] writes:
create rule blah_update as
on update to blah
do
notify TestEvent;
UPDATE blah SET n1=n1+1; -- Won't crash the connection
UPDATE blah SET n1=2 WHERE var_field='aaa' AND n1=1 AND n2=2 AND arr_str IS
Bruce Momjian [EMAIL PROTECTED] writes:
Is there a TODO item here, Tom?
Hopefully we can just decide what to do and do it. I'm waiting to hear
Jan's opinion ...
regards, tom lane
Tom Lane wrote:
"Steve Howe" [EMAIL PROTECTED] writes:
create rule blah_update as
on update to blah
do
notify TestEvent;
UPDATE blah SET n1=n1+1; -- Won't crash the connection
UPDATE blah SET n1=2 WHERE var_field='aaa' AND n1=1 AND n2=2 AND arr_str IS
NULL AND m IS NULL;
"Steve Howe" [EMAIL PROTECTED] writes:
Please try this script, it will crash the current connection.
Crash confirmed. Thanks for the report --- I'm on it...
regards, tom lane
"Steve Howe" [EMAIL PROTECTED] writes:
create rule blah_update as
on update to blah
do
notify TestEvent;
UPDATE blah SET n1=n1+1; -- Won't crash the connection
UPDATE blah SET n1=2 WHERE var_field='aaa' AND n1=1 AND n2=2 AND arr_str IS
NULL AND m IS NULL; -- Will crash the
11 matches
Mail list logo