Skip site navigation (1) Skip section navigation (2)

Insert error

From: Atif Jung <atifjung(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Insert error
Date: 2010-06-23 10:23:55
Message-ID: AANLkTil3KjEwsuwZY5GPJ_wTsqFzFe1Za1uXT4rXRY1U@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
The following lines inserts a row into table pending_file

 +1757          /* Add a row to pending_file */
 +1758          EXEC SQL INSERT INTO pending_file
 +1759          (submission_no, orc, terminal_id, initials, user_id,
output_to_file, output_path, item_id)
 +1760          VALUES (:sSubNo, :sORC, :sTermID, :sInit, :sUserID, "1",
:sOutPath, :sItemID);

The table definition in postgres is:

     Column      |          Type          | Modifiers
-----------------+------------------------+-----------
 submission_no   | character(11)           | not null
 item_id              | character(9)             | not null
 terminal_id         | character(3)             |
 initials               | character(2)              |
 user_id              | character(20)            |
 orc                    | character(1)              |
 output_to_file     | character(1)               |
 output_path       | character varying(200) |
 gui_calling         | character(1)               |
 date                  | date                          |
 calling_process  | integer                      |

The error being recorded by sqlca.sqlerrm.sqlerrmc is:

column "1" does not exist on line 1758.

I'm totally baffled, can anyone kindly explain what the error is referring
to?

Thanks

Atif

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2010-06-23 10:35:01
Subject: Re: Insert error
Previous:From: Dimitri FontaineDate: 2010-06-23 10:02:43
Subject: Re: libpython - cannot open shared object file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group