RPostgreSQL
RPostgreSQL copied to clipboard
tomoakin
Automatically exported from code.google.com/p/rpostgresql
When libpq is not installed in the user's system, the user does not get an appropriate error message. The package configure script attempts to use a bundled distribution but fails...
**Steps to reproduce:** * Establish a connection to some DB * Run a query that would not return any rows, but which would anyway have defined columns, e.g. ```r con
I cannot find a way to get the autogenerated keys after an INSERT statement. Is there a way to do this like in JDBC? https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getGeneratedKeys%28%29
Not works with `dbGetQuery`: ```r Error in postgresqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not Retrieve the result : ОШИБКА: столбец "aaa" не существует LINE 1: SELECT aaa ^ )...
``` What steps will reproduce the problem? 1. Configure PostgreSQL client and server to use UTF-8 encoding (this is the default). To verify, dbGetQuery(con_master, "SHOW server_encoding"); # "UTF-8" dbGetQuery(con_master, "SHOW...
Quoting from the [current docs](https://www.postgresql.org/docs/current/static/libpq-pgservice.html): The connection service file allows libpq connection parameters to be associated with a single service name. That service name can then be specified by a...
DBIConnection methods _dbExistTable(), dbReadTable(), dbWriteTable()_ do not perform as expected on non-public database schemas unless the **`options`** parameter is included in **dbConnect()**, as answered on [stackoverflow](https://stackoverflow.com/questions/42139964/setting-the-schema-name-in-postgres-using-r#49110504), eg : `dbConnect(drv, dbuser,...
Using the binary OSX package on CRAN, connections fail to a Redshift server that requires SSL, but when the package is installed from source, the connections succeed. When I attempt...
From https://github.com/tidyverse/dplyr/issues/3516 . Notice how violently the value is rounded when round-tripped through the database. The amount of rounding depends on the driver (so may not be a pure `DBI`...
