[postgis-devel] [OT] postgresql raise notice is giving me a major headache

Stephen Woodbridge woodbri at swoodbridge.com
Thu Sep 5 15:51:39 PDT 2013


Hi all,

We have a bunch of functions in pgrouting that output a lot of 
informational NOTICE messages to the user.

In our automated tests, we collect the command output and compare it to 
a reference file. The headache is the no two versions of postgresql 
output the same format for these messages. So a lot of our test fail 
with false positive errors. We are testing on pg versions 9.0, 9.1 and 
9.2 and I guess we should be adding 9.3 soon also.

I guess the obvious answer is to not compare the notice messages. But I 
don't like that answer.

Any better thoughts on this?

-Steve



More information about the postgis-devel mailing list