| 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: | Whole Thread | Raw Message | 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 |