From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | emilu(at)encs(dot)concordia(dot)ca |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? |
Date: | 2011-07-06 22:06:27 |
Message-ID: | 4E14DC63.7040505@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | lists-pgsql | 2011-07-08 18:50:47 | Re: overload |
Previous Message | Gavin Flower | 2011-07-06 19:38:10 | Re: interesting sequence (Correctin) |