Thread: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
Good morning, A question about: ERROR: malformed record literal: "" DETAIL: Missing left parenthesis. Can someone tell me what cause the error? ======================== Table z_drop; Column | Type -------------+------------------------ run_date | character varying(128) adm_year | character varying(4) adm_sess | character varying(1) faculty | character varying(128) ac_cycle | character varying(128) deg_code | charactervarying(128) discipline | character varying(128) thesis | character varying(128) elig_stype | character varying(128)stud_source | character varying(128) applied | numeric reviewed | numeric accepted | numeric confirmed | numeric registered | numeric hold | numeric forward | numeric refused | numeric cancelled | numeric other | numeric pending | numeric PREPARE test(z_drop) AS INSERT INTO z_drop VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) ; EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1', '0', '0', '0', '0', '0', '0', '0', '0') ; Thank you, Emi
> A question about: ERROR: malformed record literal: "" > DETAIL: Missing left parenthesis. > > Can someone tell me what cause the error? > > ======================== > Table z_drop; > Column | Type > -------------+------------------------ > run_date | character varying(128) > adm_year | character varying(4) > adm_sess | character varying(1) > faculty | character varying(128) > ac_cycle | character varying(128) > deg_code | character varying(128) > discipline | character varying(128) > thesis | character varying(128) > elig_stype | character varying(128) > stud_source | character varying(128) > applied | numeric > reviewed | numeric > accepted | numeric > confirmed | numeric > registered | numeric > hold | numeric > forward | numeric > refused | numeric > cancelled | numeric > other | numeric > pending | numeric > > > PREPARE test(z_drop) AS INSERT INTO z_drop VALUES ($1, $2, $3, $4, $5, > $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, > $21) ; I have fixed it. It should not be z_drop, it should be real column names. The mailing list email appears so slow :-( Only after 4 hours it show! Emi > > EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1', > '0', '0', '0', '0', '0', '0', '0', '0') ; > > > > > Thank you, > Emi > -- Emi Lu, ENCS, Concordia University, Montreal H3G 1M8 emilu@encs.concordia.ca +1 514 848-2424 x5884
On 07/06/2011 12:03 PM, Emi Lu wrote: > >> A question about: ERROR: malformed record literal: "" >> DETAIL: Missing left parenthesis. >> >> Can someone tell me what cause the error? >> >> ======================== >> Table z_drop; >> Column | Type >> -------------+------------------------ >> run_date | character varying(128) >> adm_year | character varying(4) >> adm_sess | character varying(1) >> faculty | character varying(128) >> ac_cycle | character varying(128) >> deg_code | character varying(128) >> discipline | character varying(128) >> thesis | character varying(128) >> elig_stype | character varying(128) >> stud_source | character varying(128) >> applied | numeric >> reviewed | numeric >> accepted | numeric >> confirmed | numeric >> registered | numeric >> hold | numeric >> forward | numeric >> refused | numeric >> cancelled | numeric >> other | numeric >> pending | numeric >> >> >> PREPARE test(z_drop) AS INSERT INTO z_drop VALUES ($1, $2, $3, $4, $5, >> $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, >> $21) ; > I have fixed it. > > It should not be z_drop, it should be real column names. > > The mailing list email appears so slow :-( Only after 4 hours it show! What happens if you do?: PREPARE test AS INSERT .... My rough guess is that z_drop is being applied to the first parameter only. > > Emi > > >> >> EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1', >> '0', '0', '0', '0', '0', '0', '0', '0') ; >> >> >> >> >> Thank you, >> Emi >> > > -- Adrian Klaver adrian.klaver@gmail.com