The following bug has been logged online: Bug reference: 4150 Logged by: Christian Lippuner Email address: [EMAIL PROTECTED] 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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs