Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?

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