Pg 0.14.1 Released

pg version 0.14.1 has been released!

Pg is the Ruby interface to the {PostgreSQL

It works with {PostgreSQL 8.3 and later}[PostgreSQL Release Support Policy - PostgreSQL wiki].

A small example usage:

#!/usr/bin/env ruby

require ‘pg’

Output a table of current connections to the DB

conn = PG.connect( dbname: ‘sales’ )
conn.exec( “SELECT * FROM pg_stat_activity” ) do |result|
puts " PID | User | Query"
result.each do |row|
puts " %7d | %-16s | %s " %
row.values_at(‘procpid’, ‘usename’, ‘current_query’)


== v0.14.1 [2012-09-02] Michael G. [email protected]

Important bugfix:

  • Fix stack overflow bug in PG::Result#values and #column_values (#135).
    to everyone who reported the bug, and Lars Kanis especially for
    figuring out
    the problem.

PostgreSQL 9.2 beta fixes:

  • Recognize PGRES_SINGLE_TUPLE as OK when checking PGresult (Jeremy

Documentation fixes:

  • Add note about the usage scope of the result object received by the
    #set_notice_receiver block. (Lars Kanis)
  • Add PGRES_COPY_BOTH to documentation of PG::Result#result_status.
    (Lars Kanis)
  • Add some documentation to PG::Result#fnumber (fix for #139)