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

help / color / mirror / Atom feed

From: Emi Lu <emilu@encs.concordia.ca>
To: pgsql-sql@postgresql.org
Subject: ERROR:  malformed record literal: "", DETAIL:  Missing left parenthesis?
Date: Wed, 06 Jul 2011 11:53:27 -0400
Message-ID: <4E1484F7.5080800@encs.concordia.ca> (raw)

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

view thread (3+ messages)  latest in thread

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

copy link · copy postgr.es

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: <4E1484F7.5080800@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