ruby-pg

1–30 of 100

Hi!

Feel free to post about any problems you may be having with installation, questions about how to use particular features, and future plans for the driver.

0 selected

Mar 10

PostgreSQL user permissions for production

Hi, I've been looking for advice on what database privileges should be granted in production to a

unread,

PostgreSQL user permissions for production

Hi, I've been looking for advice on what database privileges should be granted in production to a

Mar 10

Tim, … Sol Martínez4

Jan 12

Problem installing Apple Silicon M1

Thanks a lot cody! After a lot of unsuccessful searches, this worked for me! On Tuesday, January 5,

unread,

Problem installing Apple Silicon M1

Thanks a lot cody! After a lot of unsuccessful searches, this worked for me! On Tuesday, January 5,

Jan 12

8/12/22

Is it possible to get the number of items as well as the list of items without re-executing the query?

I have a non-Rails, Ruby project using “pg” and Postgres 14. I like what I call “baby sitting

unread,

Is it possible to get the number of items as well as the list of items without re-executing the query?

I have a non-Rails, Ruby project using “pg” and Postgres 14. I like what I call “baby sitting

8/12/22

3/2/21

Ruby on Rails / PostgreSQL Version Compatibility

Version compatibility finding #1: Rails 5.1.5. is required to use pg gem 1.0 or higher. On Tuesday,

unread,

Ruby on Rails / PostgreSQL Version Compatibility

Version compatibility finding #1: Rails 5.1.5. is required to use pg gem 1.0 or higher. On Tuesday,

3/2/21

Jack Royal-Gordon, … Jack Royal-Gordon3

10/12/20

Can't install 0.14.1 on OSX Lion

Hi Lars, Thanks for your response. Actually, while that appeared to be the problem it really wasn

unread,

Can't install 0.14.1 on OSX Lion

Hi Lars, Thanks for your response. Actually, while that appeared to be the problem it really wasn

10/12/20

Jack Royal-Gordon2

10/5/20

Problem building native extensions for pg 0.15.1

Output from pg_config: BINDIR = /Applications/Postgres.app/Contents/Versions/10/bin DOCDIR = /

unread,

Problem building native extensions for pg 0.15.1

Output from pg_config: BINDIR = /Applications/Postgres.app/Contents/Versions/10/bin DOCDIR = /

10/5/20

studdugie, Lars Kanis5

9/16/20

I'm doing something wrong with copy_data

The columns sent have to exactly match the table columns, if you send a COPY command without column

unread,

I'm doing something wrong with copy_data

The columns sent have to exactly match the table columns, if you send a COPY command without column

9/16/20

6/24/20

Database Connection Issues

Hi folks. I was using the PG gem to connect to databases, almost as a very light ORM. I was having

unread,

Database Connection Issues

Hi folks. I was using the PG gem to connect to databases, almost as a very light ORM. I was having

6/24/20

Perry Smith, Jeremy Evans6

3/20/20

Version mismatch

On Friday, March 20, 2020 at 11:45:50 AM UTC-7, Perry Smith wrote: ruby-pg uses libpq — does it not?

unread,

Version mismatch

On Friday, March 20, 2020 at 11:45:50 AM UTC-7, Perry Smith wrote: ruby-pg uses libpq — does it not?

3/20/20

10/5/19

OpenSSL : help needed for Ruby 2.3 on Debian 10

Hi guys, first of all, thank you very much for your fine work with pg lib, it has proven to be very

unread,

OpenSSL : help needed for Ruby 2.3 on Debian 10

Hi guys, first of all, thank you very much for your fine work with pg lib, it has proven to be very

10/5/19

natha...@gmail.com, Jeremy Evans2

8/30/19

Prevent "cached plan must not change result type" errors with the Ruby pg driver

On Friday, August 30, 2019 at 11:43:29 AM UTC-7, Nathan Broadbent wrote: Hello! I've been trying

unread,

Prevent "cached plan must not change result type" errors with the Ruby pg driver

On Friday, August 30, 2019 at 11:43:29 AM UTC-7, Nathan Broadbent wrote: Hello! I've been trying

8/30/19

Carlos Ferreira da Silva

8/18/19

New version of Torque PostgreSQL GEM

Hey everyone! Just coming here to say that I have just released a new version of my GEM! I'm very

unread,

New version of Torque PostgreSQL GEM

Hey everyone! Just coming here to say that I have just released a new version of my GEM! I'm very

8/18/19

Carlos Ferreira da Silva, … Lars Kanis5

8/18/19

Well, now that I'm using I'm own GEM, I solved the decode thing over there: https://github.

unread,

Well, now that I'm using I'm own GEM, I solved the decode thing over there: https://github.

8/18/19

BeeRich33, Lars Kanis3

4/18/19

WHERE creation_date::timestamp::date > (CURRENT_DATE - interval '30 days')::date

So params aren't directly translated like string interpolation in Ruby. I see. I'm guessing

unread,

WHERE creation_date::timestamp::date > (CURRENT_DATE - interval '30 days')::date

So params aren't directly translated like string interpolation in Ruby. I see. I'm guessing

4/18/19

BeeRich33, … Chris Bandy8

4/7/19

OK, none of this is column-dependent. It's about qualifying using lists. IN {array} NOT IN {array

unread,

OK, none of this is column-dependent. It's about qualifying using lists. IN {array} NOT IN {array

4/7/19

Constantin Gavrilescu, Jeremy Evans4

1/18/19

Exiting forked child closes connection in parent

On Friday, January 18, 2019 at 11:19:37 AM UTC-6, Constantin Gavrilescu wrote: On Wednesday, December

unread,

Exiting forked child closes connection in parent

On Friday, January 18, 2019 at 11:19:37 AM UTC-6, Constantin Gavrilescu wrote: On Wednesday, December

1/18/19

mic...@knotch.com, … Lars Kanis4

12/11/18

List of causes for PG::InvalidChangeOfResultFields exceptions

If I remember right, this error happens when prepared statements are outdated. ActiveRecord makes use

unread,

List of causes for PG::InvalidChangeOfResultFields exceptions

If I remember right, this error happens when prepared statements are outdated. ActiveRecord makes use

12/11/18

zzzo...@gmail.com

9/18/18

LoadError: cannot load such file -- pg_ext

> rake populate:users C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/activesupport-4.1.1/lib

unread,

LoadError: cannot load such file -- pg_ext

> rake populate:users C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/activesupport-4.1.1/lib

9/18/18

sbel...@gmail.com, Robert Klemme3

6/9/18

How to get data from a server function that executes a query

Robert, Turns out the problem was with the way I was calling the server function. Once I corrected it

unread,

How to get data from a server function that executes a query

Robert, Turns out the problem was with the way I was calling the server function. Once I corrected it

6/9/18

martin.s...@gmail.com, Lars Kanis3

1/11/18

pg 1.0.0 gem and Rails/bundler

Thank you. That answers my question. On Thursday, 11 January 2018 15:43:28 UTC-5, Lars Kanis wrote:

unread,

pg 1.0.0 gem and Rails/bundler

Thank you. That answers my question. On Thursday, 11 January 2018 15:43:28 UTC-5, Lars Kanis wrote:

1/11/18

Lars Kanis, aleks...@ledovskis.lv2

1/2/18

Re: PostgreSQL 10 SCRAM-SHA-256 ruby-pg encryption support

Hello, I have just re-tested my own setup and indeed it works! Previously, while have ensured client

unread,

Re: PostgreSQL 10 SCRAM-SHA-256 ruby-pg encryption support

Hello, I have just re-tested my own setup and indeed it works! Previously, while have ensured client

1/2/18

Kevin Griffin, Michael Granger2

10/11/17

PostgreSQL 10 support?

On 9 Oct 2017, at 19:11, Kevin Griffin wrote: > Are any changes needed to support PostgreSQL 10?

unread,

PostgreSQL 10 support?

On 9 Oct 2017, at 19:11, Kevin Griffin wrote: > Are any changes needed to support PostgreSQL 10?

10/11/17

AG, … mar...@workable.com4

9/28/17

DuplicatePstatement

I'm guessing it might be related to job timeouts as well. Don't know if the prepared

unread,

DuplicatePstatement

I'm guessing it might be related to job timeouts as well. Don't know if the prepared

9/28/17

Refael Dakar, … Robert Klemme7

7/12/17

Multiple exec calls on the same connection from threads

perfect. thanks! On Wednesday, July 12, 2017 at 10:17:52 AM UTC+3, Robert Klemme wrote: On Wed, Jul

unread,

Multiple exec calls on the same connection from threads

perfect. thanks! On Wednesday, July 12, 2017 at 10:17:52 AM UTC+3, Robert Klemme wrote: On Wed, Jul

7/12/17

BeeRich33, … p...@citylink.dinoex.sub.org10

6/28/17

Segmentation Fault on "require 'pg'"

Problem seems solved. Am Freitag, 11. November 2016 02:15:30 UTC+1 schrieb Michael Granger: 1. Your

unread,

Segmentation Fault on "require 'pg'"

Problem seems solved. Am Freitag, 11. November 2016 02:15:30 UTC+1 schrieb Michael Granger: 1. Your

6/28/17

Svoop, … rajan....@kiprosh.com13

4/20/17

Sporadic StatementInvalid: relation "sessions" does not exist

Try commenting 'ActionController::Base.session_store = :active_record_store' in your

unread,

Sporadic StatementInvalid: relation "sessions" does not exist

Try commenting 'ActionController::Base.session_store = :active_record_store' in your

4/20/17

4/12/17

Store large binary data without loading it all into memory

Hi all! I am converting a Rails app to MRI from JRuby and I am looking for a way to store large

unread,

Store large binary data without loading it all into memory

Hi all! I am converting a Rails app to MRI from JRuby and I am looking for a way to store large

4/12/17

BeeRich33, … Cody Cutrer13

3/21/17

Gem Install PG on Raspbian through RVM

Which is why I came in here, and got the answer. Lars put me in the right direction, and it worked.

unread,

Gem Install PG on Raspbian through RVM

Which is why I came in here, and got the answer. Lars put me in the right direction, and it worked.

3/21/17

John Smart, Lars Kanis4

11/2/16

RangeError - integer 364834158948831939 too big to convert to `int'

You must use "$1" as the placeholder for bind parameters (not "?"). It should

unread,

RangeError - integer 364834158948831939 too big to convert to `int'

You must use "$1" as the placeholder for bind parameters (not "?"). It should

11/2/16

smar...@gmail.com, … John Smart3

11/2/16

ActiveRecord::StatementInvalid (PG::NotNullViolation: ERROR: ....) Can not rescue?

Check if the rescued error is_a? PG::NotNullViolation or rescue that type specifically.

unread,

ActiveRecord::StatementInvalid (PG::NotNullViolation: ERROR: ....) Can not rescue?

Check if the rescued error is_a? PG::NotNullViolation or rescue that type specifically.

11/2/16

Search

Clear search

Close search

Google apps

Main menu