similar to: Limits on Postgresql integers not respected

Hello, Currently if you have a string column that have only number values (think a year column using string by mistake) and you want to change to integer, you can''t. If you apply this monkey-patch will be possible: https://gist.github.com/1393441 Note: if some value can''t be casted by postgresql (if have a letter for example), the migration will fail as expected. I think

So that I can know there is test coverage on this in the Rails core, and I won''t have to maintain a private monkey-patch indefinitely, fixing it again every time it''s broken in a new and different way up-stream, I''m hoping to get this pull request accepted some day... ... or rejected in an informative manner, if that''s more appropriate.

Hi there, I''ve been trying for a few hours now to get RoR and postgresql talking - but I''m very confused about what''s going on (I''m running windows btw). I haven''t created a database in postgresql (I''m assuming that RoR will do that?) my database.yml looks like this: production: adapter: ruby-postgres database: rails_production

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

Hi there. I''m having a problem here: I''m trying to install pg-0.7.9.2008.10.05 (The last version), but I get this... PATH=/opt/PostgreSQL/8.3/bin:$PATH gem install pg Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb install pg checking for main() in -lpq...

CentOS Errata and Security Advisory 2012:0678 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-0678.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 84ec4f5147f1794dedf496cb3be490a0ded24073018e92cd3a4c931a7d9598dc postgresql-8.4.11-1.el6_2.i686.rpm

CentOS Errata and Security Advisory 2012:1037 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-1037.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: ac5806bdf1eafdb0d494f1c9fa3f0db6d7bb7a7341846c7f79cc2875f5c6357a postgresql-8.4.12-1.el6_2.i686.rpm

CentOS Errata and Security Advisory 2012:1263 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-1263.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 961ef503db4cbdaa64686c64b44051509c36efefbb0b6d4e7ae02af9e12811ed postgresql-8.4.13-1.el6_3.i686.rpm

CentOS Errata and Security Advisory 2013:1475 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2013-1475.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: e53a1f5a363c266e787c5250c270cc50cccc5e3cc07d737c9110740482fbe595 postgresql-8.4.18-1.el6_4.i686.rpm

CentOS Errata and Security Advisory 2014:0211 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2014-0211.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 6ca3a1beea5f113655e4abdf43ba3447ae836639bff9381e372bc6cc9d2172ab postgresql-8.4.20-1.el6_5.i686.rpm

CentOS Errata and Security Advisory 2015:0750 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2015-0750.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 9b1c5e6fc09b4bd771526bba9121531dd56ae1066a7e976fcb0a9e59424ecf01 postgresql-8.4.20-2.el6_6.i686.rpm

CentOS Errata and Security Advisory 2015:1194 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2015-1194.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 38011c1a69aac2d06e4309c0fa4cf17d8fa3f6393d9b99116365d277bf9df8a4 postgresql-8.4.20-3.el6_6.i686.rpm

CentOS Errata and Security Advisory 2015:2081 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2015-2081.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 0e97fe4a73fd3e52d253aa01a78d4a2c75e57415e62a2468dc8639352016e817 postgresql-8.4.20-4.el6_7.i686.rpm

CentOS Errata and Security Advisory 2016:0347 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2016-0347.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 28887eb490932c082e1b7b1265d02162825dc1441e4a3a42bb5512b7f4640c22 postgresql-8.4.20-5.el6_7.i686.rpm

CentOS Errata and Security Advisory 2017:2860 Moderate Upstream details at : https://access.redhat.com/errata/RHSA-2017:2860 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 8ce524d7594d44842dbf2c6a918fba0df6eb4aba61456a1afac2956b49cea425 postgresql-8.4.20-8.el6_9.i686.rpm

CentOS Errata and Security Advisory 2012:0677 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-0677.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: f9e276c942b735df8aaa8f64f17a141d718a9804bff7773f1ff06a07fd47db83 postgresql-8.1.23-4.el5_8.i386.rpm

CentOS Errata and Security Advisory 2012:1036 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-1036.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 068825619d5167000cb31c985932b60d79424045d1324d92fe986e95ec93e29a postgresql-8.1.23-5.el5_8.i386.rpm

CentOS Errata and Security Advisory 2012:1264 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2012-1264.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 5e29c038ddc1527fa9a0ff5353b041274f1644a410b81ba069ec3ec95ecb3b21 postgresql-8.1.23-6.el5_8.i386.rpm

CentOS Errata and Security Advisory 2014:0249 Important Upstream details at : https://rhn.redhat.com/errata/RHSA-2014-0249.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 894c94c7e573d62e918cf3f95f9904e8441967a7afa4d9e5da0cf7313196ba45 postgresql-8.1.23-10.el5_10.i386.rpm

CentOS Errata and Security Advisory 2008:0039 https://rhn.redhat.com/errata/RHSA-2008-0039.html The following updated files have been uploaded and are currently syncing to the mirrors: s390: updates/s390/RPMS/rh-postgresql-7.3.21-1.s390.rpm updates/s390/RPMS/rh-postgresql-contrib-7.3.21-1.s390.rpm updates/s390/RPMS/rh-postgresql-devel-7.3.21-1.s390.rpm