RPostgres
RPostgres copied to clipboard
r-dbi
A DBI-compliant interface to PostgreSQL
I would like to list tables in a specific schema using `dbListTables` and use syntax that will work with other DBI backends that support listing tables in a schema (e.g....
@zozlak: In https://man7.org/linux/man-pages/man2/select.2.html I read: > WARNING: select() can monitor only file descriptors numbers that are less than FD_SETSIZE (1024)—an unreasonably low limit for many modern applications—and this limitation will...
Hi, We're getting intermittent timeout error while querying Redshift: _Error: Failed to prepare query: SSL SYSCALL error: Connection timed out_. While this occurred, I checked the Redshift connection list and...
Hey @krlmlr, it looks like #370 causes issues for queries that rely on implicit conversion (https://github.com/ankane/dbx/issues/30). ```r library(DBI) db [1] 0 dbExecute(db, "CREATE TABLE t (col jsonb)") #> [1] 0...
Since updating from RPostgres 1.3.3 to 1.4.3, I'm getting this error on one of my Redshift queries when I don't expect: `Error: Multiple queries must use the same column types.`...
I try to execute an INSERT statement with placeholders in my Postgres DB. This gives me a syntax error. This problem occurs also with the example from the DBI package...
This is an attempt to only allow `Id()` objects as `prefix` argument to `dbListObjects()` as mentioned in https://github.com/r-dbi/RPostgres/pull/372#issuecomment-1003884250. prefix can now be a list with multiple `Id` objects, so querying...
`dbQuoteIdentifier()` currently does not allow for columns when quoting an `Id()` object. library(DBI) con - Session info --------------------------------------------------------------- #> setting value #> version R version 4.0.2 (2020-06-22) #> os Windows...
Attempting to connect to [arcadedb](https://arcadedb.com/) which [claims to support the Postgres wire format](https://docs.arcadedb.com/#Postgres-Driver) for connections and queries, an error "received invalid response to GSSAPI negotiation: R" appears. ## Brief description...
