pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: malformed record literal: "", DETAIL: Missing left parenthesis?
3+ messages / 2 participants
[nested] [flat]
* ERROR: malformed record literal: "", DETAIL: Missing left parenthesis?
@ 2011-07-06 15:53 Emi Lu <emilu@encs.concordia.ca>
2011-07-06 19:03 ` Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
0 siblings, 1 reply; 3+ messages in thread
From: Emi Lu @ 2011-07-06 15:53 UTC (permalink / raw)
To: pgsql-sql
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 | 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) ;
EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1',
'0', '0', '0', '0', '0', '0', '0', '0') ;
Thank you,
Emi
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
2011-07-06 15:53 ERROR: malformed record literal: "", DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
@ 2011-07-06 19:03 ` Emi Lu <emilu@encs.concordia.ca>
2011-07-06 22:06 ` Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Adrian Klaver <adrian.klaver@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Emi Lu @ 2011-07-06 19:03 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
2011-07-06 15:53 ERROR: malformed record literal: "", DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
2011-07-06 19:03 ` Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
@ 2011-07-06 22:06 ` Adrian Klaver <adrian.klaver@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Adrian Klaver @ 2011-07-06 22:06 UTC (permalink / raw)
To: emilu@encs.concordia.ca; +Cc: 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.klaver@gmail.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-07-06 22:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-07-06 15:53 ERROR: malformed record literal: "", DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
2011-07-06 19:03 ` Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Emi Lu <emilu@encs.concordia.ca>
2011-07-06 22:06 ` Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Adrian Klaver <adrian.klaver@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox