Re: [HACKERS] This script will crash the connection

2001-01-26 Thread Bruce Momjian
> 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 i

Re: [HACKERS] This script will crash the connection

2001-01-26 Thread 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? "Allow NO

Re: [HACKERS] This script will crash the connection

2001-01-26 Thread Bruce Momjian
> 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? --

Re: [HACKERS] This script will crash the connection

2001-01-26 Thread 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 ... regards, tom lane

Re: [HACKERS] This script will crash the connection

2001-01-26 Thread Bruce Momjian
> > 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 sol

Re: [HACKERS] This script will crash the connection

2001-01-26 Thread Tom Lane
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 c

Re: [HACKERS] This script will crash the connection

2001-01-24 Thread Jan Wieck
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 > > NU

Re: [HACKERS] This script will crash the connection

2001-01-24 Thread Tom Lane
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

Re: [HACKERS] This script will crash the connection

2001-01-24 Thread Bruce Momjian
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 AN

Re: [HACKERS] This script will crash the connection

2001-01-23 Thread 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 t

Re: [HACKERS] This script will crash the connection

2001-01-23 Thread Tom Lane
"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