Re: BUG #2821: xid cannot be casted to a different type

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@mavetju.org    |          Weblog: http://weblog.barnet.com.au/edwin/