From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Edwin Groothuis <edwin(at)mavetju(dot)org>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2821: xid cannot be casted to a different type |
Date: | 2006-12-11 07:09:42 |
Message-ID: | 457D0436.9090403@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Tom Lane wrote:
> Edwin Groothuis <edwin(at)mavetju(dot)org> writes:
>> On Sun, Dec 10, 2006 at 03:20:50PM -0500, Tom Lane wrote:
>>> "Edwin Groothuis" <mavetju(at)gmail(dot)com> writes:
>>>> This worked fine on 8.0.x.
>>> Really?
>
>> Hmm... We used this script on 8.0.0 to 8.0.6 (which is the current
>> database version we're running), so when I tested it on 8.0.6, I
>> assumed it was fine on all 8.0.>6 too:
>
> There was no change between 8.0 and 8.0.9 on such a point, because
> adding or removing a cast would have required an initdb which we don't
> do in minor releases. Just to prove it, I checked out 8.0.6 and
> rebuilt it:
>
> template1=# select version();
> version
> ----------------------------------------------------------------------------------------------------------
> PostgreSQL 8.0.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20060525 (Red Hat 4.1.1-1)
> (1 row)
>
> template1=# select relation,transaction::bigint,count(*) as waiting from
> template1-# pg_locks where not granted group by relation,transaction;
> ERROR: cannot cast type xid to bigint
> template1=# select relation,transaction,count(*) as waiting from
> template1-# pg_locks where not granted group by relation,transaction;
> ERROR: could not identify an ordering operator for type xid
> HINT: Use an explicit ordering operator or modify the query.
>
>
>> Except that there isn't a custom cast...
>
> Better look harder; there's *something* nonstandard about your 8.0
> database.
if I had to guess I would say that there is slony installed in the old
database(slony installs operators for comparing XID) ...
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Filip Hrbek | 2006-12-11 09:06:44 | BUG #2822: Missing support for IBM852 |
Previous Message | Edwin Groothuis | 2006-12-11 00:59:20 | Re: BUG #2821: xid cannot be casted to a different type |