From: | Denis de Bernardy <ddebernardy(at)yahoo(dot)com> |
---|---|
To: | PG Testers <pgsql-testers(at)postgresql(dot)org> |
Subject: | Re: PG 9.1 regression / row comparison? |
Date: | 2011-06-15 21:07:29 |
Message-ID: | 743036.48052.qm@web112401.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-testers |
I've actually traced it down to btree_gist. Not sure if this is the expected behavior:
test =# 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 operator families.
test=# drop extension btree_gist cascade;
NOTICE: drop cascades to constraint test_period_excl on table test.test_revs
DROP EXTENSION
test =# select row(1,2) <> row(1,2);
?column?
----------
f
(1 row)
>________________________________
>From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
>To: ddebernardy(at)yahoo(dot)com
>Cc: pgsql-testers(at)postgresql(dot)org
>Sent: Wednesday, June 15, 2011 4:40 AM
>Subject: Re: [TESTERS] PG 9.1 regression / row comparison?
>
>[...]
>> test=# 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 operator > families.
>
>Hi Denis,
>
>I don't get this error with 9.1beta2,
>
>$ uname -a
>Linux saturn 2.6.35.13-92.fc14.x86_64 #1 SMP Sat May 21 17:26:25 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux
>$ psql
>psql (9.1beta2)
>Type "help" for help.
>
>gavin=> select row(1,2) <> row(1,2);
>?column?
>----------
>f
>(1 row)
>
>
>Cheers,
>Gavin
>-
>HOWTO Alpha/Beta Test:
>http://wiki.postgresql.org/wiki/HowToBetaTest
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-testers
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-06-16 05:37:17 | Re: BUG #6062: psql terminates on auto-complete |
Previous Message | Sebastian | 2011-06-15 19:22:16 | BUG #6062: psql terminates on auto-complete |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Watson | 2011-06-16 18:05:56 | Re: 9.1Beta1 - Repeatable Crash on Windows |
Previous Message | Gavin Flower | 2011-06-15 02:40:32 | Re: PG 9.1 regression / row comparison? |