BUG #4150: ecpg: update/insert of array data does not work anymore since Version 8.2

Поиск
Список
Период
Сортировка
От Christian Lippuner
Тема BUG #4150: ecpg: update/insert of array data does not work anymore since Version 8.2
Дата
Msg-id 200805091702.m49H2ngR080498@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4150
Logged by:          Christian Lippuner
Email address:      cl@eps.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Aleksej Saushev
Дата:
Сообщение: Re: BUG #4053: libpq documentation should express clearly, that integers are passed in network octet order
Следующее
От: Martin Pitt
Дата:
Сообщение: Re: reproducible database crash with simple sql command