pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@gmail.com>
To: emilu@encs.concordia.ca
Cc: pgsql-sql@postgresql.org
Subject: Re: ERROR:  malformed record literal: "",DETAIL:  Missing left parenthesis?
Date: Wed, 06 Jul 2011 15:06:27 -0700
Message-ID: <4E14DC63.7040505@gmail.com> (raw)
In-Reply-To: <4E14B164.9060302@encs.concordia.ca>
References: <4E1484F7.5080800@encs.concordia.ca>
	<4E14B164.9060302@encs.concordia.ca>

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



view thread (3+ messages)

Message-ID: <4E14DC63.7040505@gmail.com>
Permalink:  ../4E14DC63.7040505@gmail.com/
Also on:    postgresql.org/message-id/4E14DC63.7040505@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: adrian.klaver@gmail.com, emilu@encs.concordia.ca
  Subject: Re: ERROR:  malformed record literal: "",DETAIL:  Missing left parenthesis?
  In-Reply-To: <4E14DC63.7040505@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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