To do so I'm using the attached 'insert.py' script.
As you see I'm reading the FITS table with
ATpy 0.9.7 module.
From there I convert the columns of tbl2 I want to insert into a numpy.array (L36), I connect to the database (password is fake but doesn't matter for the purpose of my question :), and then I get the error in around cur.mogrify in L54:
Traceback (most recent call last):
File "insert.py", line 54, in <module>
args_str = ','.join(cur.mogrify("(%s,%s,%s,%s,%s,%s,%s,%s)", x) for x in targets)
File "insert.py", line 54, in <genexpr>
args_str = ','.join(cur.mogrify("(%s,%s,%s,%s,%s,%s,%s,%s)", x) for x in targets)
TypeError: not all arguments converted during string formatting
The 'referencecat' table definition is the following:
CREATE TABLE referencecat
(
ref_id bigserial NOT NULL, -- SEXtractor running reference object number.
ref_alphawin_j2000 double precision, -- Windowed right ascension (J2000).
ref_deltawin_j2000 double precision, -- Windowed declination (J2000).
ref_object character varying(18), -- Source identificator from (RA,DEC): JHHMMSSSS+DDMMSSSS
ref_snr real, -- SNR (flux_auto / fluxerr_auto)
ref_elongation real, -- A_IMAGE/B_IMAGE
ref_fwhm_image real, -- FWHM assuming a gaussian core.
ref_flags character varying(3), -- Extraction flags.
CONSTRAINT pk_ref_id PRIMARY KEY (ref_id)
)
WITH (
OIDS=FALSE
);
I've been struggling and googling searching for a solution but unsuccessfully :(
Could anybody please provide some light into this?
Any advise/help would be more than welcome.
Thanks a lot in advance,
Octavi.