BUG #10014: Does not work PQfn in libpq with array

From: aleksey(dot)vitaliev(at)transas(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10014: Does not work PQfn in libpq with array
Date: 2014-04-14 08:42:48
Message-ID: 20140414084248.15390.12810@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10014
Logged by: Vitalyev Aleksey
Email address: aleksey(dot)vitaliev(at)transas(dot)com
PostgreSQL version: 9.2.4
Operating system: Windows 7
Description:

I have a store procedure __a(INT[] args). I try execute this procedure with
libpq and call PQfn function. How should I transmit array of int from c++
code?
I get only this message "number of array dimensions (16777216) exceeds the
maximum allowed (6)"

This is my code:
int result_buf = 0;
int result_len = 0;
int result_is_int = 0;

PQArgBlock args[1];
int iFrom[] = {1,2};
args[0].len = sizeof(iFrom) * 2;
args[0].isint = 0;
args[0].u.ptr = reinterpret_cast<int*> ( iFrom );

PGresult* res = PQfn( m_conn, 1447769, &result_buf, &result_len,
result_is_int, args, 1 );
if ( PQresultStatus(res) != PGRES_COMMAND_OK )
{
::OutputDebugStringA( m_stringUtil.FormatEx("ExecFunc
failed!\n%s\n", PQresultErrorMessage(res)) );

ReleaseResult( res );
return false;
}
ReleaseResult( res );
return true;

This is store procedure:
CREATE OR REPLACE FUNCTION ___a(oldUniqId INT[]) RETURNS BOOLEAN AS
$$
BEGIN
RETURN TRUE;

END
$$ LANGUAGE plpgsql VOLATILE STRICT;
ALTER FUNCTION ___a(INT[])
OWNER TO postgres;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message kona ajay 2014-04-14 10:20:13 cant insert into a postgre sql table from c# please help to solve this......... |Thanks very much in advance
Previous Message kona ajay 2014-04-14 07:51:53 Fwd: cant insert into a post gre sql table...Can u please help in fixing this