Groups

RPostgreSQL Development and Discussion List

1–30 of 93

0 selected

Jessica San Francisco G

4/14/22

Error install.packages("RPostgres") had non-zero exit status

Please I need help, I´m tryn to install the packages Rpostgres in my R sesion but i can´t. My log:

unread,

Error install.packages("RPostgres") had non-zero exit status

Please I need help, I´m tryn to install the packages Rpostgres in my R sesion but i can´t. My log:

4/14/22

Venu Kovelamudi

5/15/20

save image using Postgresql C API'S

How to save the image using Postgresql C API'S

unread,

save image using Postgresql C API'S

How to save the image using Postgresql C API'S

5/15/20

mst...@newrelic.com, … Begli10

3/12/18

RPostgreSQL won't connect anymore, but it used to

Hi there, Just responded to Ellen's post, but in case you miss it, here are my notes from a few

unread,

RPostgreSQL won't connect anymore, but it used to

Hi there, Just responded to Ellen's post, but in case you miss it, here are my notes from a few

3/12/18

weber.g...@gmail.com, Ian Gow2

2/16/18

Timezone and POSIXct handling in RpostgreSQL

Sam: I posted a reply of sorts on StackOverflow. Seems either to be a bug in RPostgreSQL (on my end)

unread,

Timezone and POSIXct handling in RpostgreSQL

Sam: I posted a reply of sorts on StackOverflow. Seems either to be a bug in RPostgreSQL (on my end)

2/16/18

no...@vicomtech.org, … Alan...3

9/21/17

Error in postgresqlNewConnection(drv, ...) : expired manager

Load the PostgreSQL driver using : drv<-dbDriver("PostgreSQL") Alan On Saturday, April 1

unread,

Error in postgresqlNewConnection(drv, ...) : expired manager

Load the PostgreSQL driver using : drv<-dbDriver("PostgreSQL") Alan On Saturday, April 1

9/21/17

Nelson Jaiva, Neil Tiffin3

8/1/16

pg_config not found during configuration

On Jul 31, 2016, at 9:48 AM, Nelson Jaiva <hei...@gmx.net> wrote: Hi, I am trying to install

unread,

pg_config not found during configuration

On Jul 31, 2016, at 9:48 AM, Nelson Jaiva <hei...@gmx.net> wrote: Hi, I am trying to install

8/1/16

6/29/16

Catch error message on dbConnect failure

When dbConnect fails, for reasons like when the Postgres connection limit is reached, the error

unread,

Catch error message on dbConnect failure

When dbConnect fails, for reasons like when the Postgres connection limit is reached, the error

6/29/16

6/28/16

future of RPostgreSQL

Hello, I've just started to develop a package that would be heavily dependent on RPostgreSQL, but

unread,

future of RPostgreSQL

Hello, I've just started to develop a package that would be heavily dependent on RPostgreSQL, but

6/28/16

John Payne, Andrew Newnham3

5/10/16

Losing times from 'Timestamp without time zone'

Thanks Andrew, that's useful. I note an earlier comment that seems to suggest that this Google

unread,

Losing times from 'Timestamp without time zone'

Thanks Andrew, that's useful. I note an earlier comment that seems to suggest that this Google

5/10/16

Ravi Varma Alluru, Neil Tiffin5

11/3/15

RpostgreSQL doesn't support hstore data type

Thank you Neil for your prompt help. The issue is resolved now. On Monday, November 2, 2015 at 8:11:

unread,

RpostgreSQL doesn't support hstore data type

Thank you Neil for your prompt help. The issue is resolved now. On Monday, November 2, 2015 at 8:11:

11/3/15

Michael Kaminsky, … Neil Tiffin4

10/7/15

RPostgreSQL error with PostgreSQL 'infinity' values in datetime data types

Please use the official github page at https://github.com/tomoakin/RPostgreSQL for issues and etc. We

unread,

RPostgreSQL error with PostgreSQL 'infinity' values in datetime data types

Please use the official github page at https://github.com/tomoakin/RPostgreSQL for issues and etc. We

10/7/15

NISHIYAMA Tomoaki, … jangorecki18

9/26/15

Re: [R-sig-DB] R and PostgreSQL - Writing data?

Sorry for resurrecting such an old discussion... "append data to table which has an ID auto-

unread,

Re: [R-sig-DB] R and PostgreSQL - Writing data?

Sorry for resurrecting such an old discussion... "append data to table which has an ID auto-

9/26/15

Marta Cretu, … Nelson Jaiva9

9/10/15

Installing RPostgreSQL on Red Hat Linux

Dear Joe, excellent - that worked. Thank's a lot your help and thank's also for the reference

unread,

Installing RPostgreSQL on Red Hat Linux

Dear Joe, excellent - that worked. Thank's a lot your help and thank's also for the reference

9/10/15

Hadley Wickham, Tony Stone2

8/11/15

Supposedly this has been resolved, see: http://stackoverflow.com/questions/28482913/connect-to-

unread,

Supposedly this has been resolved, see: http://stackoverflow.com/questions/28482913/connect-to-

8/11/15

Bibudh Lahiri, … mst...@newrelic.com18

6/22/15

RS-DBI over SSL?

Is there a way to do this without certificate validation? When I connect via a sql client, I just add

unread,

RS-DBI over SSL?

Is there a way to do this without certificate validation? When I connect via a sql client, I just add

6/22/15

NISHIYAMA Tomoaki

6/8/15

Re: RPostgreSQL: prepared statements?

Dear Pavel, Thank you for the interest in contributing RPostgreSQL. prepared statement is the second

unread,

Re: RPostgreSQL: prepared statements?

Dear Pavel, Thank you for the interest in contributing RPostgreSQL. prepared statement is the second

6/8/15

Richard Cotton, Jonathan Adams3

4/6/15

How to write to tables with an auto-incrementing primary key?

Richard, I don't know if you are still having trouble with this, but I too was having the same

unread,

How to write to tables with an auto-incrementing primary key?

Richard, I don't know if you are still having trouble with this, but I too was having the same

4/6/15

Domenico Giusti, Neil Tiffin3

3/30/15

dbListTables doen't list views. dbListViews?

Dear Neil, it works, thank you! ## Submits a statement rs <- dbSendQuery(con, "SELECT

unread,

dbListTables doen't list views. dbListViews?

Dear Neil, it works, thank you! ## Submits a statement rs <- dbSendQuery(con, "SELECT

3/30/15

Neil Tiffin, … Ian Gow4

3/12/15

Google Code Shutting Down

On OS X, RPostgres seems to have Homebrew as a dependency. I took a look at it, but it wanted to

unread,

Google Code Shutting Down

On OS X, RPostgres seems to have Homebrew as a dependency. I took a look at it, but it wanted to

3/12/15

da...@farmersbusinessnetwork.com2

1/13/15

New feature for RPostgreSQL: service and sslmode parameters

On Monday, January 5, 2015 at 3:18:50 PM UTC-8, da...@farmersbusinessnetwork.com wrote: Folks, I'

unread,

New feature for RPostgreSQL: service and sslmode parameters

On Monday, January 5, 2015 at 3:18:50 PM UTC-8, da...@farmersbusinessnetwork.com wrote: Folks, I'

1/13/15

10/30/14

Postgres errors getting printed twice

Hello, I'm running into an error where all postgres error messages are returned twice: once in a

unread,

Postgres errors getting printed twice

Hello, I'm running into an error where all postgres error messages are returned twice: once in a

10/30/14

10/22/14

Wondering how to use the data from a results set

Hi, Thanks for this library! I'm following the instructions and can get to my results set, but

unread,

Wondering how to use the data from a results set

Hi, Thanks for this library! I'm following the instructions and can get to my results set, but

10/22/14

James David Smith, … Ian Gow3

10/14/14

Use file as SQL?

James: I find myself doing something quite similar to what you describe and I find myself using

unread,

Use file as SQL?

James: I find myself doing something quite similar to what you describe and I find myself using

10/14/14

7/21/14

dbWriteTable() of PostGIS enabled database

I'm trying to import a spatial database (PostGIS) to R using the RpostgreSQL package. When I use

unread,

dbWriteTable() of PostGIS enabled database

I'm trying to import a spatial database (PostGIS) to R using the RpostgreSQL package. When I use

7/21/14

6/29/14

Failed to set default locale

Hello All, I'm new to R, trying to install RPostgreSQL pacakage, but get the following error

unread,

Failed to set default locale

Hello All, I'm new to R, trying to install RPostgreSQL pacakage, but get the following error

6/29/14

NISHIYAMA Tomoaki2

6/19/14

Re: Upgrade from RPostgresql 0.3-3 to 0.4 (just this week) breaks our query - TIMESTAMP not coming through correctly?

Dear Mark, If you need world-wide support, SET timezone to 'UTC' as http://www.postgresql.org

unread,

Re: Upgrade from RPostgresql 0.3-3 to 0.4 (just this week) breaks our query - TIMESTAMP not coming through correctly?

Dear Mark, If you need world-wide support, SET timezone to 'UTC' as http://www.postgresql.org

6/19/14

Rebecca Ackerman3

6/3/14

Syntax error when installing in R 3.1, OSX Mavericks

Resolved! If anyone else has this problem, the issue was actually with an old version of awk in

unread,

Syntax error when installing in R 3.1, OSX Mavericks

Resolved! If anyone else has this problem, the issue was actually with an old version of awk in

6/3/14

NISHIYAMA Tomoaki, … Jose Luis Velasco6

6/3/14

Fwd: RPostgreSQL on OS X 10.9

Hello again, Problem solved. I have installed the Postgres application and I have included in .

unread,

Fwd: RPostgreSQL on OS X 10.9

Hello again, Problem solved. I have installed the Postgres application and I have included in .

6/3/14

David Andel, NISHIYAMA Tomoaki5

5/29/14

segfault: address (nil), cause 'memory not mapped'

Perfect, thanks! This helped me a lot. Now I can work with the tables I get from the web. I will not

unread,

segfault: address (nil), cause 'memory not mapped'

Perfect, thanks! This helped me a lot. Now I can work with the tables I get from the web. I will not

5/29/14

5/20/14

Regarding License reference

The License file refers to 'COPYING' in the following text but am unable to understand where

unread,

Regarding License reference

The License file refers to 'COPYING' in the following text but am unable to understand where

5/20/14

Search

Clear search

Close search

Google apps

Main menu