Re: 7.3b2 ?bug? bitfromint4 is not working

> Is it worth an initdb for 7.3b3 to fix this? I think we were already
> considering forcing one for the command-tag issues, otherwise I'd
> probably vote "no". Comments?

Do we need an initdb to fix command tags? I thought that was just a
change in the Query structure.

---------------------------------------------------------------------------

Tom Lane wrote:
> Neophytos Demetriou <k2pts(at)cytanet(dot)com(dot)cy> writes:
> > I must be missing something obvious here but it seems that bitfromint4
> > is not working under 7.3b2. I can still see bitfromint4 in the source
> > code, utils/adt/varbit.c, but it is no longer working. Any ideas why?
>
> It's still there:
>
> regression=# select "bit"(42);
> bit
> ----------------------------------
> 00000000000000000000000000101010
> (1 row)
>
> However, it's not listed in pg_cast :-(
>
> regression=# select cast(42 as bit);
> ERROR: Cannot cast type integer to bit
>
> Looking at the CVS logs, this seems to be caused by overlapping changes.
> On 4-Aug Thomas renamed bittoint4 and bitfromint4 to match the more
> usual naming conventions for cast functions, viz int4(bit) and
> bit(int4), and he also added int8(bit) and bit(int8). This was after
> Peter had trolled the catalogs for cast functions and created the
> initial contents of pg_cast.h (on 18-Jul).
>
> Upshot: we have here four functions that ought to be in pg_cast and are
> not.
>
> Is it worth an initdb for 7.3b3 to fix this? I think we were already
> considering forcing one for the command-tag issues, otherwise I'd
> probably vote "no". Comments?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073