Skip site navigation (1) Skip section navigation (2)

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

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Kristis Makris <kristis(dot)makris(at)datasoft(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC 7.01.00.05 driver fails when text arrays are passed in asarguments to backend plpgsql functions
Date: 2001-06-13 05:07:00
Message-ID: 3B26F4F4.E6F69A43@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: Henshall, Stuart - WCPDate: 2001-06-13 08:32:33
Subject: RE: pg_hba.conf
Previous:From: Johann ZuschlagDate: 2001-06-12 18:30:30
Subject: Re: Image to Postgresql database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group