Thread: win32/1.8.4 newlines inconsistent in Query window's Messages pane
Whenever I have a standard 'raise notice' in one of my functions for debugging, and I run a select statement on the function in the query, the Messages pane only sometimes puts newlines after "NOTICE: ..." lines, and if I just keep hitting F5, it's after different lines every time. Often there are many lines in a row with newlines, and often there are many in a row that are bunched together without newlines: NOTICE: test NOTICE: test NOTICE: test NOTICE: test NOTICE: test NOTICE: testNOTICE: testNOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: test Total query runtime: 344 ms. 1 rows retrieved. NOTICE: test NOTICE: test NOTICE: test NOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: test Total query runtime: 453 ms. 1 rows retrieved. If I do this in psql, all newlines come out correctly, one after each "NOTICE" line.
<tt>Hi Kev,<br /><br /> I have tried to reproduce this case with the version 1.8.4, and as you said - i am getting the sameissue.<br /> But, when I tried to do the same thing with the latest source (checked out from svn), surprisingly the problemdisappear.<br /><br /> If you can run your testcase(s) with latest source or share the testcase(s) with us, that wouldbe help to investigate the problem.<br /><br /> Regards,<br /> Ashesh<br /></tt><br /> Kev wrote: <blockquote cite="mid:27784704-def8-4c62-9494-eabfadad6ec1@n33g2000pri.googlegroups.com"type="cite"><pre wrap="">Whenever I have a standard'raise notice' in one of my functions for debugging, and I run a select statement on the function in the query, the Messages pane only sometimes puts newlines after "NOTICE: ..." lines, and if I just keep hitting F5, it's after different lines every time. Often there are many lines in a row with newlines, and often there are many in a row that are bunched together without newlines: NOTICE: test NOTICE: test NOTICE: test NOTICE: test NOTICE: test NOTICE: testNOTICE: testNOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: test Total query runtime: 344 ms. 1 rows retrieved. NOTICE: test NOTICE: test NOTICE: test NOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: testNOTICE: testNOTICE: test NOTICE: testNOTICE: test Total query runtime: 453 ms. 1 rows retrieved. If I do this in psql, all newlines come out correctly, one after each "NOTICE" line. </pre></blockquote>
On Wed, Nov 5, 2008 at 5:14 AM, Ashesh D Vashi <ashesh.vashi@enterprisedb.com> wrote: > Hi Kev, > > I have tried to reproduce this case with the version 1.8.4, and as you said > - i am getting the same issue. > But, when I tried to do the same thing with the latest source (checked out > from svn), surprisingly the problem disappear. > > If you can run your testcase(s) with latest source or share the testcase(s) > with us, that would be help to investigate the problem. Hmm, I may have wasted your time I'm afraid Ashesh :-(. I had a glance over http://svn.pgadmin.org, and found this commit (which I had completely forgotten about) which may explain things: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi?rev=7388&view=rev That change is in trunk, and will be in 1.8.5 if it's ever released. Sorry. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
> On Wed, Nov 5, 2008 at 5:14 AM, Ashesh D Vashi > <ashesh.vashi@enterprisedb.com> wrote: > > Hi Kev, > > > > I have tried to reproduce this case with the version 1.8.4, and as > > you said > > - i am getting the same issue. > > But, when I tried to do the same thing with the latest source > > (checked out > > from svn), surprisingly the problem disappear. > > > > If you can run your testcase(s) with latest source or share the > > testcase(s) > > with us, that would be help to investigate the problem. > > Hmm, I may have wasted your time I'm afraid Ashesh :-(. I had a > glance > over http://svn.pgadmin.org, and found this commit (which I had > completely forgotten about) which may explain things: > > http://svn.pgadmin.org/cgi-bin/viewcvs.cgi?rev=7388&view=rev > > That change is in trunk, and will be in 1.8.5 if it's ever released. > > Sorry. Thanks Ashesh and Dave, I'll try to remember to check the commit log next time too. Peace out, Kev