From: | Edwin Groothuis <edwin(at)mavetju(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2821: xid cannot be casted to a different type |
Date: | 2006-12-11 00:59:20 |
Message-ID: | 20061211005920.GG90169@k7.mavetju |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Sun, Dec 10, 2006 at 05:47:16PM -0500, Tom Lane wrote:
> > Except that there isn't a custom cast...
> Better look harder; there's *something* nonstandard about your 8.0
> database.
Thanks for the push, I found it: It is part of slony which isn't
on the new databases:
mail=> select oid,* from pg_catalog.pg_type where typname='xid';
oid | typname | typnamespace | typowner | typlen | typbyval | typtype |
28 | xid | 11 | 1 | 4 | t | b |
mail=> select * from pg_catalog.pg_cast where castsource=28;
castsource | casttarget | castfunc | castcontext
------------+------------+----------+-------------
28 | 21800 | 0 | i
mail=> select oid,* from pg_catalog.pg_type where oid=21800;
oid | typname | typnamespace | typowner | typlen | typbyval | typtype | typisdefined | typdelim | typrelid | typelem | typinput | typoutput | typreceive | typsend | typanalyze | typalign | typstorage | typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault
-------+---------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+------------------------+-------------------------+------------+---------+------------+----------+------------+------------+-------------+-----------+----------+---------------+------------
21800 | xxid | 21799 | 1 | 4 | t | b | t | , | 0 | 0 | _upsreplication.xxidin | _upsreplication.xxidout | - | - | - | i | p | f | 0 | -1 | 0 | |
When running it on a test database with 8.1.5 with replication
enabled it works fine there too.
Sorry about the noise,
Edwin
--
Edwin Groothuis | Personal website: http://www.mavetju.org
edwin(at)mavetju(dot)org | Weblog: http://weblog.barnet.com.au/edwin/
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-12-11 07:09:42 | Re: BUG #2821: xid cannot be casted to a different type |
Previous Message | Tom Lane | 2006-12-10 22:47:16 | Re: BUG #2821: xid cannot be casted to a different type |