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

help / color / mirror / Atom feed
From: Emi Lu <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:03:00 -0400
Message-ID: <4E14B164.9060302@encs.concordia.ca> (raw)
In-Reply-To: <4E1484F7.5080800@encs.concordia.ca>
References: <4E1484F7.5080800@encs.concordia.ca>


> 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



view thread (3+ messages)  latest in thread

Message-ID: <4E14B164.9060302@encs.concordia.ca>
Permalink:  ../4E14B164.9060302@encs.concordia.ca/
Also on:    postgresql.org/message-id/4E14B164.9060302@encs.concordia.ca

 · 

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: emilu@encs.concordia.ca
  Subject: Re: ERROR:  malformed record literal: "",DETAIL:  Missing left parenthesis?
  In-Reply-To: <4E14B164.9060302@encs.concordia.ca>

* 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