From: | "Christian Lippuner" <cl(at)eps(dot)ch> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4150: ecpg: update/insert of array data does not work anymore since Version 8.2 |
Date: | 2008-05-09 17:02:49 |
Message-ID: | 200805091702.m49H2ngR080498@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: 4150
Logged by: Christian Lippuner
Email address: cl(at)eps(dot)ch
PostgreSQL version: 8.2.7/8.3.1
Operating system: Linux
Description: ecpg: update/insert of array data does not work anymore
since Version 8.2
Details:
From version 7.3 up to 8.1 the following code works fine:
EXEC SQL BEGIN declare section;
static short sqlNumber;
static short sqlTestArray[8];
EXEC SQL END declare section;
..
..
EXEC SQL UPDATE test_table SET
number = :sqlNumber,
testarray = :sqlTestArray
WHERE number = :sqlNumber;
stat = sqlca.sqlcode;
...
...
Since Version 8.2 I get the following error message after
precompiling/compiling/linking this code:
"array value must start with "{" or dimension information"
In general all updating or insert of new data with an array doesn't work
anymore sing Version 8.2.
Reading the data just works fine.
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Pitt | 2008-05-09 17:10:10 | Re: reproducible database crash with simple sql command |
Previous Message | Tom Lane | 2008-05-09 14:18:37 | Re: reproducible database crash with simple sql command on postgres 8.3.1 |