Re: ODBC 7.01.00.05 driver fails when text arrays are passed in asarguments to backend plpgsql functions

Kristis Makris wrote:
>
> Hello all,
>
> I'm facing a problem with the latest 7.01.00.05 ODBC driver used under
> win2000 through MSVC++ 6.0, executing statements to a PostgreSQL 7.1.2
> on a i686-pc-linux-gnu, compiled by GCC egcs-2.91.66. In particular, the
> driver ?crashes? when the following postgres plpgsql function is called:
>
> ESPRateForWResource_cleanup(TEXT[], INT4, INT4) RETURNS INT4
>
> The statement executed is:
>
> SELECT ESPRateForWResource_cleanup ('{''C-1'', ''C-2''}', 2, 3)
>
> I have also tried the following with the same success:
> SELECT ESPRateForWResource_cleanup ('{"C-1", "C-2"}', 2, 3)
>
> The driver reports the following (as shown in the logs):
>
> +++++++++++++++++==+++++++++++++++++==+++++++++++++++++==+++++++++++++++++==
> conn=32424464, query='SELECT ESPRateForWResource_cleanup ('{''C-1'',
> ''C-2''}', 2, 3)'
>     [ fetched 1 rows ]
> STATEMENT ERROR: func=SC_execute, desc='', errnum=-1, errmsg='Error
> while executing the query (non-fatal)'
>                  ------------------------------------------------------------
>                  hdbc=32424464, stmt=32581216, result=32439368
>                  manual_result=0, prepare=0, internal=0
>                  bindings=32439864, bindings_allocated=1
>                  parameters=0, parameters_allocated=0
>                  statement_type=0, statement='SELECT
> ESPRateForWResource_cleanup ('{''C-1'', ''C-2''}', 2, 3)'
>                  stmt_with_params='SELECT ESPRateForWResource_cleanup
> ('{''C-1'', ''C-2''}', 2, 3)'
>                  data_at_exec=-1, current_exec_param=-1, put_data=0
>                  currTuple=-1, current_col=-1, lobj_fd=-1
>                  maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
> scroll_concurrency=1
>                  cursor_name='SQL_CUR01F12660'
>                  ----------------QResult Info
> -------------------------------
>                  fields=32439472, manual_tuples=0,
> backend_tuples=32646984, tupleField=32646984, conn=32424464
>                  fetch_count=0, fcount=1, num_fields=1, cursor='(NULL)'
>                  message='NOTICE:  Hello world - 4

The NOTICE message(Hello world - 4) seems to cause the error.

regards,
Hiroshi Inoue