[postgis-users] New line in a notice.

[Nicolas Gillet - MARKET-IP]

Hello,

 

Thank you for your answer.


Actually had tried this already and it doesn’t work.

The result of 

“RAISE NOTICE 'test \r';

RAISE NOTICE 'test \r';”

Is

“NOTICE:  test rNOTICE:  test r”

Same as \n, only ‘n’ char is displayed.

I wonder if it isn’t some kind of difference between windows and unix system
for the definition of new line.

 

In log files, notices are displayed properly, no need of CR/LF characters.

But it is not really convenient to read logs as there’re also some other log
info I don’t want to read.

 

Regards,

 

Nicolas

 

De : postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] De la part de Clay,
Bruce
Envoyé : jeudi 15 octobre 2009 18:18
À : PostGIS Users Discussion
Objet : Re: [postgis-users] New line in a notice.

 

Try \r.  It works in many cases where \n does not

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Nicolas
Gillet - MARKET-IP
Sent: Thursday, October 15, 2009 3:31 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] New line in a notice.

 

Hello

 

I am debugging a plpgsql script putting some RAISE NOTICE '
' in my code but
in PG admin III in the "message Panel" all NOTICE messages are in one single
line.

It becomes impossible to read it 


 

So I am looking for any tips helping me to display each NOTICE on a single
line.

I have tried \n and chr(10) but without success :’(

 

I am working on Windows XP, Postgres 8.3 under PGAdmin III

 

Thank you

 

Nicolas.

 
 
This message and any enclosures are intended only for the addressee.  Please

notify the sender by email if you are not the intended recipient.  If you
are  
not the intended recipient, you may not use, copy, disclose, or distribute
this  
message or its contents or enclosures to any other person and any such
actions  
may be unlawful.  Ball reserves the right to monitor and review all messages

and enclosures sent to or from this email address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091016/cd28c9b0/attachment.html>