| From: | "Mikael Omma" <mikael(dot)omma(at)ge(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4091: ECPG $select incompability with Informix |
| Date: | 2008-04-04 12:38:22 |
| Message-ID: | 200804041238.m34CcMbW007189@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4091
Logged by: Mikael Omma
Email address: mikael(dot)omma(at)ge(dot)com
PostgreSQL version: 8.2.6
Operating system: SUSE Linux 10
Description: ECPG $select incompability with Informix
Details:
ECPG "$select a, b, c into :a, :b, :c from table".
If in the db table the order of columns (b, a, c) this will not work. I
have ESQL code from Informix ported to PostgreSQL. In informix the order in
columns in the select query does not have to match the real order in the
table of the database. Workaround is to reorder all columns in the ported
code.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-04 14:46:28 | Re: BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts. |
| Previous Message | Mikael Omma | 2008-04-04 12:32:44 | BUG #4090: ECPG Selecting table with NULL values |