Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BC76FB5DBCC for ; Wed, 15 Jun 2011 18:07:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 25270-03 for ; Wed, 15 Jun 2011 21:07:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm28.bullet.mail.sp2.yahoo.com (nm28.bullet.mail.sp2.yahoo.com [98.139.91.98]) by mail.postgresql.org (Postfix) with SMTP id 93C78B5DBC0 for ; Wed, 15 Jun 2011 18:07:31 -0300 (ADT) Received: from [98.139.91.69] by nm28.bullet.mail.sp2.yahoo.com with NNFMP; 15 Jun 2011 21:07:30 -0000 Received: from [98.139.91.35] by tm9.bullet.mail.sp2.yahoo.com with NNFMP; 15 Jun 2011 21:07:30 -0000 Received: from [127.0.0.1] by omp1035.mail.sp2.yahoo.com with NNFMP; 15 Jun 2011 21:07:30 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 210474.72672.bm@omp1035.mail.sp2.yahoo.com Received: (qmail 52358 invoked by uid 60001); 15 Jun 2011 21:07:29 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1308172049; bh=qR1R1DQY6KBXjmenZH2amRisdvzTa0NrAry8MkDuBjs=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=Gc++wmOhyG4n2CeDD67Tv0r+JAV4enO0Tcrm4OBTFhwVaoxqvZ5a9x47c+3IXv3CpSMXxJ4aOjVFMqphDv8/bXjnIbU3o731x7ye/iRCRbj1exn0+7eBRJOwfNoepCPjbYOCeZWWgi/uhXIofrLnYSuL66Er6PV7MoH3oUyq2OM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=FgDdtr387dJaltztBNdmf5RviMdFdcg+S+XKpP/EDQDNvYRHLv1a9m1mPCs+ODTZal+6papiBP9xI+jbldAdx2ZIb0eG7OXdVGiI9sAIXmfh12ciyFfs16AxLldHFPqcMLH2a0zdEMdz/34UrMlXraV8S3Rh+I68b+OAP7ceqQ0=; Message-ID: <743036.48052.qm@web112401.mail.gq1.yahoo.com> X-YMail-OSG: RmsqBOEVM1kGhGFj04i04IVv7diplumqqc_r2xslENLs_sz BeMQxhMnEOs84qqhgWr6xwONlTKtOtI5JuTc0MIM1KaxoEDKjK8f6mxX8Sbx SpL3SI0G0fQ1WNhNLJ8LDpH7L.8sOhKAMX0kmNNI1KoRu1fI3TG5oCdVv1Wn J2_Qfep_MPytSA5YE7uJdhehqQMQz4tPsHMH8RPOQSsJKAZJYDWniZ_LnDWa xNzkUU0YN9WjaXcZOROXwKM2.su3PIuqkLtDrNz1fCrd.9.Y4z1waY8ANa6w aYU.X3Uu5IHGd2dLauFUW97mt5TMN4s7uai9MUAqNdgdXvKuFuGYHNI1yLun 51mxrtgs3.iIzIdSnU31TRDmRWcdGiqXGBfjPgIiAFF.1AGQvBWENxLLrLx2 V.bzzCySl Received: from [88.203.16.8] by web112401.mail.gq1.yahoo.com via HTTP; Wed, 15 Jun 2011 14:07:29 PDT X-Mailer: YahooMailWebService/0.8.111.304355 References: <4DF81BA0.3000601@archidevsys.co.nz> Date: Wed, 15 Jun 2011 14:07:29 -0700 (PDT) From: Denis de Bernardy Reply-To: Denis de Bernardy Subject: Re: PG 9.1 regression / row comparison? To: PG Testers In-Reply-To: <4DF81BA0.3000601@archidevsys.co.nz> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-322172355-1308172049=:48052" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.907 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/3 X-Sequence-Number: 244 --0-322172355-1308172049=:48052 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I've actually traced it down to btree_gist. Not sure if this is the expecte= d behavior:=0A=0Atest=A0=3D# select row(1,2) <> row(1,2);=0AERROR: =A0could= not determine interpretation of row comparison operator <>=0ALINE 1: selec= t row(1,2) <> row(1,2);=0A=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0^=0AHINT: =A0Row comparison operators must be associated with btree oper= ator families.=0A=0Atest=3D# drop extension btree_gist cascade;=0ANOTICE: = =A0drop cascades to constraint test_period_excl on table test.test_revs=0AD= ROP EXTENSION=0Atest=A0=3D# select row(1,2) <> row(1,2);=0A=A0?column?=A0= =0A----------=0A=A0f=0A(1 row)=0A=0A=0A=0A=0A>_____________________________= ___=0A>From: Gavin Flower =0A>To: ddebernard= y@yahoo.com=0A>Cc: pgsql-testers@postgresql.org=0A>Sent: Wednesday, June 15= , 2011 4:40 AM=0A>Subject: Re: [TESTERS] PG 9.1 regression / row comparison= ?=0A>=0A>[...]=0A>> test=3D# select row(1,2) <> row(1,2);=0A>>=0A>> ERROR:= =A0 could not determine interpretation of row comparison operator <>=0A>> L= INE 1: select row(1,2) <> row(1,2);=0A>>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 ^=0A>> HINT:=A0 Row comparison operators must be associated w= ith btree operator > families.=0A>=0A>Hi Denis,=0A>=0A>I don't get this err= or with 9.1beta2,=0A>=0A>$ uname -a=0A>Linux saturn 2.6.35.13-92.fc14.x86_6= 4 #1 SMP Sat May 21 17:26:25 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux=0A>$ p= sql=0A>psql (9.1beta2)=0A>Type "help" for help.=0A>=0A>gavin=3D> select row= (1,2) <> row(1,2);=0A>?column?=0A>----------=0A>f=0A>(1 row)=0A>=0A>=0A>Che= ers,=0A>Gavin=0A>-=0A>HOWTO Alpha/Beta Test:=0A>http://wiki.postgresql.org/= wiki/HowToBetaTest=0A>To make changes to your subscription:=0A>http://www.p= ostgresql.org/mailpref/pgsql-testers=0A>=0A>=0A> --0-322172355-1308172049=:48052 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I've actua= lly traced it down to btree_gist. Not sure if this is the expected behavior= :

test =3D# se= lect row(1,2) <> row(1,2);
ERROR:  could not determine= interpretation of row comparison operator <>
LINE 1: selec= t row(1,2) <> row(1,2);
         &= nbsp;              ^
HINT: &nb= sp;Row comparison operators must be associated with btree operator families= .

test=3D# drop extension btree_gist cascade;=
NOTICE:  drop cascades to constraint test_period_excl on ta= ble test.test_revs
DROP EXTENSION
test =3D# select= row(1,2) <> row(1,2);
 ?column? 
----------
&n= bsp;f
(1 row)



From:= Gavin Flower <GavinFlower@archidevsys.co.nz>
To: ddebernardy@yahoo.com
Cc: pgsql-testers@postgresql.org
<= b>Sent: Wednesday, June 15, 2= 011 4:40 AM
Subject: Re= : [TESTERS] PG 9.1 regression / row comparison?

=0A[...]
&= gt; test=3D# select row(1,2) <> row(1,2);
>
> ERROR: = ; could not determine interpretation of row comparison operator <>> LINE 1: select row(1,2) <> row(1,2);
>     = ;                   ^
>= HINT:  Row comparison operators must be associated with btree operato= r > families.

Hi Denis,

I don't get this error with 9.1bet= a2,

$ uname -a
Linux saturn 2.6.35.13-92.fc14.x86_64 #1 SMP Sat M= ay 21 17:26:25 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux
$ psql
psql (9= .1beta2)
Type "help" for help.

gavin=3D> select row(1,2) <&= gt; row(1,2);
?column?
----------
f
(1 row)


Cheers= ,
Gavin
-
HOWTO Alpha/Beta Test:
http://wiki.postgresql.org/wik= i/HowToBetaTest
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-testers

<= br>
--0-322172355-1308172049=:48052--