Re: pika failing since the per-column collation patch - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pika failing since the per-column collation patch
Date
Msg-id 1297533076.6286.3.camel@vanquo.pezone.net
Whole thread Raw
In response to pika failing since the per-column collation patch  (Rémi Zara <remi_zara@mac.com>)
Responses Re: pika failing since the per-column collation patch  (Rémi Zara <remi_zara@mac.com>)
List pgsql-hackers
On lör, 2011-02-12 at 13:34 +0100, Rémi Zara wrote:
> Since the per-column collation patch went in, pika (NetBSD 5.1/mips) started failing consistently with this diff:
> 
> *** /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/expected/polymorphism.out    Sat Feb 12 02:16:07
2011
> --- /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/results/polymorphism.out    Sat Feb 12 09:10:21 2011
> ***************
> *** 624,630 ****
>   
>   -- such functions must protect themselves if varying element type isn't OK
>   select max(histogram_bounds) from pg_stats;
> ! ERROR:  cannot compare arrays of different element types
>   -- test variadic polymorphic functions
>   create function myleast(variadic anyarray) returns anyelement as $$
>     select min($1[i]) from generate_subscripts($1,1) g(i)
> --- 624,630 ----
>   
>   -- such functions must protect themselves if varying element type isn't OK
>   select max(histogram_bounds) from pg_stats;
> ! ERROR:  locale operation to be invoked, but no collation was derived
>   -- test variadic polymorphic functions
>   create function myleast(variadic anyarray) returns anyelement as $$
>     select min($1[i]) from generate_subscripts($1,1) g(i)
> 
> Is there something I can do to help investigate this ?

It's only failing on this one machine, but there isn't anything
platform-specific in this code, so I'd look for memory management faults
on the code or a compiler problem.  Try with lower optimization for a
start.



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Extensions vs PGXS' MODULE_PATHNAME handling
Next
From: "Kevin Grittner"
Date:
Subject: Re: SSI bug?