Update existing system explicit cast to make it implicit

Hi,

I am trying to use bit(1) datatype with existing application that used int datatype before.
So I tried to create implicit cast that will allow me not to make code modifications and wanted to create implicit cast "int2bit", but it turned out that there is already system cast.
Unfortunately this cast is explicit and I need to make it implicit (it can be made implicit only for one schema).

My question is that if there is any official way to overwrite this attribute instead of performing following query:

update pg_cast set castcontext = 'i' where oid in (
select c.oid
from pg_cast c
inner join pg_type src on src.oid = c.castsource
inner join pg_type tgt on tgt.oid = c.casttarget
where src.typname like 'int%' and tgt.typname like 'bit%')

Thank you in advance for advice.

Asia

asia123321(at)op(dot)pl writes:
> I am trying to use bit(1) datatype with existing application that used int datatype before.
> So I tried to create implicit cast that will allow me not to make code modifications and wanted to create implicit cast "int2bit", but it turned out that there is already system cast.
> Unfortunately this cast is explicit and I need to make it implicit (it can be made implicit only for one schema).

You will likely find that this is a really bad idea. Implicit
casts between fundamentally different datatypes are *dangerous*.
They tend to result in either surprising query behaviors or unexpected
"operator is not unique" failures. Fixing the app would be a lot safer
in the long run.

> My question is that if there is any official way to overwrite this attribute

No. If you're intent on breaking things, hacking the catalog is what to do.

regards, tom lane