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.

"Inoue, Hiroshi" <[email protected]>
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <[email protected]>
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.


-- 
Sent via pgsql-odbc mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.