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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2010-06-23 10:35:01 | Re: Insert error |
Previous Message | Dimitri Fontaine | 2010-06-23 10:02:43 | Re: libpython - cannot open shared object file |