Can't connection to the server with disabled prepare statements

[artemklevtsov]

Hi,

I can't connect to the server with following command:

con <- DBI::dbConnect(
    drv = RPostgres::Postgres(),
    host = "10.10.0.1",
    port = 5432,
    dbname = "postgres",
    user = "user",
    password = "1368798451"
)
#> Error in result_create(conn@ptr, statement) :
#>   Failed to retrieve query result metadata: ERROR:  unnamed prepared statement does not exist

With odbc package the connection works only with UseServerSidePrepare = No option in .odbc.ini. RPostgreSQL works without additional manipulations.

Server info:

PostgreSQL 9.3.20 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit

packageVersion("RPostgres")
#> [1] '1.1.0'

[krlmlr]

Interesting. RPostgres uses prepared statements by default, this might explain what we're seeing. Could this be a configuration issue on the server side?

[artemklevtsov]

Server's admin confirmed that the prepared statements disable on the server side. This was done to prevent performance problems.
So can you provide fallback mode for this case?

[krlmlr]

Unfortunately, RPostgres currently requires prepared statements, I'm not aware of a fallback mode. Not sure what's needed to provide one either.

How do I disable prepared statements on the server for testing?

[artemklevtsov]

I could not find information about disable the prepare statements.

[krlmlr]

This will be fixed once we have support for the immediate argument to dbGetQuery() and dbSendQuery().

[krlmlr]

Now discussed in #272.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.