[Dachs-support] unknown data type 'L' in FITS booster

Markus Demleitner msdemlei at ari.uni-heidelberg.de
Tue Nov 22 09:49:55 CET 2016


Hi Carlos,

On Mon, Nov 21, 2016 at 09:16:38AM -0200, carlosadean at linea.gov.br wrote:
> 
> ./sample/s.rd
> 
>  <column name="SNX3" type="bytea" description="" ucd="" unit="">
>      <values nullLiteral="-9999" />
>  </column>
> 
> 
> [carlosadean at devel2 inputs [master]]$ psql -h desdb4 -U gavo gavo
> psql (8.4.1, server 9.2.9)
> WARNING: psql version 8.4, server version 9.2.
>          Some psql features might not work.
> Type "help" for help.
> 
> gavo=# select snx3 from sample.fits limit 10;
>  snx3 
> ------
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
>  \x00
> (10 rows)

Looks all right to me -- declaring snx3 as bytea (which I recommend
against, since bytea as "tiny int" has issues; just use smallint)
leads to

  gavo=# select distinct snx3 from txt.fits;
    snx3  
  --------
   \x0000
   \x0001

on my box, which is what I'd expect.

Cheers,

        Markus



More information about the Dachs-support mailing list