Re: A POSSIBLE BUG: The ODBC standard procedure call ("{ CALL function(param) }") is disallowed in ReadOnly ODBC mode whereas "SELECT * FROM function(param)" is let through.

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Matej Mihelič <Matej(dot)Mihelic(at)neosys(dot)si>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: A POSSIBLE BUG: The ODBC standard procedure call ("{ CALL function(param) }") is disallowed in ReadOnly ODBC mode whereas "SELECT * FROM function(param)" is let through.
Date: 2017-08-25 08:23:43
Message-ID: 75bbc094-326e-b8bc-ae1d-4908ade5bc22@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Matej,

On 2017/08/25 13:13, Matej Mihelič wrote:
> * A POSSIBLE BUG: The ODBC standard procedure call ("{ CALL function(param) }") is disallowed in ReadOnly ODBC mode whereas "SELECT * FROM function(param)" is let through.
>
> Good morning.
>
> Since the ODBC "{CALL..}" statement is translated to a "SELECT..FROM..." this seems like an error.

Thanks.

Honestly I've never worried about Read Only option.
DECLARE/FETCH/CLOSE or WITH( CTE) command had better be allowed too.

regards,
Hiroshi Inoue

> -- Regards, Matej.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus 2017-08-25 08:39:58 Re: Connectivity error: Could not convert from the current locale to wide characters
Previous Message Inoue, Hiroshi 2017-08-25 08:02:49 Re: Connectivity error: Could not convert from the current locale to wide characters