[postgis-devel] [pgrouting-dev] [OT] postgresql raise notice isgiving me a major headache

Stephen Woodbridge woodbri at swoodbridge.com
Fri Sep 6 06:10:19 PDT 2013


Yes, this is 32/64 bit TSP issue I mentioned. I'll look into this issue.
I think we are ok not that we have eliminated the NOTICE checking.

Thanks,
   -Steve

On 9/6/2013 4:03 AM, Paragon Corporation wrote:
> Actually the numbers are different between 64-bit and 32-bit so I guess it's
> the other issue you mentioned about a bit related
> I do have notices disabled.
>
>
> Breakdown is
>
> pg9.3w32 : 'z_crash' => 0,
>             'z_fail' => 0,
>             'z_pass' => 65
>
> pg9.3 w64:  'z_crash' => 0,
>             'z_fail' => 1,
>             'z_pass' => 64
>
> pg9.2w32:  'z_crash' => 0,
>             'z_fail' => 0,
>             'z_pass' => 65
>
>   pg9.2w64:  'z_crash' => 0,
>             'z_fail' => 1,
>             'z_pass' => 64
>
> Pg 9.1w64:    'z_crash' => 0,
>             'z_fail' => 1,
>             'z_pass' => 64
>
> -----Original Message-----
> From: pgrouting-dev-bounces at lists.osgeo.org
> [mailto:pgrouting-dev-bounces at lists.osgeo.org] On Behalf Of Paragon
> Corporation
> Sent: Friday, September 06, 2013 2:55 AM
> To: 'PostGIS Development Discussion'
> Cc: 'pgRouting Dev List'
> Subject: Re: [pgrouting-dev] [postgis-devel] [OT] postgresql raise notice
> isgiving me a major headache
>
> Steve,
>
>
> I presume the differences in errors I'm seeing on winnie are because of the
> notice issue.
>
> pg 9.3    'z_crash' => 0,
>             'z_fail' => 1,
>             'z_pass' => 64
>
>
> pg 9.2
>             'z_crash' => 0,
>             'z_fail' => 4,
>             'z_pass' => 61
>
> pg 9.1
>              'z_crash' => 0,
>             'z_fail' => 1,
>             'z_pass' => 64
>
> I haven't looked closely at them to see. I thought I had notice checking
> disabled though so perhaps something different since I do recall Before they
> were all passing.
>
>
> -----Original Message-----
> From: postgis-devel-bounces at lists.osgeo.org
> [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Paul Ramsey
> Sent: Thursday, September 05, 2013 6:58 PM
> To: PostGIS Development Discussion
> Subject: Re: [postgis-devel] [OT] postgresql raise notice is giving me a
> major headache
>
> Not really, you can see that we had to write our own regression harness
> (run_test) as soon as we supported multiple versions of PgSQL.
>
> P
>
> --
> Paul Ramsey
> http://cleverelephant.ca
> http://postgis.net
>
>
> On Thursday, September 5, 2013 at 3:51 PM, Stephen Woodbridge wrote:
>
>> 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
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org (mailto:postgis-devel at lists.osgeo.org)
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>




More information about the postgis-devel mailing list