similar to: Fixed #columns_for_distinct of postgresql adapter

am i wrong, or does the 1.0 Postgresql (postgres-pr) adapter not support a :socket option? After picking through the postgres-pr source, turns out you have to set: host; /var/run/postgresql (Does anyone know if the native lib supports that? Having some trouble building it.) I''ll update the wiki in any case. -- Rasputin :: Jack of All Trades - Master of Nuns

Hi I am trying to get RoR to work with Postgresql 8,2.5 (latest stable version) Steps taken 1. Download Postgresql 1.82 and installed successfully 2. Edited my Database.yml development: adapter: postgresql database: test_development username: postgres password: xxx host: localhost test: adapter: postgresql database: test_test username: postgres password: xxx host: localhost

Hi, When i m using Postgresql database with puppetdb in puppet 3.0.2, following error is coming. err: Could not retrieve catalog from remote server: Error 400 on SERVER: Failed to submit ''replace facts'' command for abcd.example.com to PuppetDB at puppet-DB.example.com:8081: Connection refused - connect(2) Can anyone have any solution regarding this? -- You received this

I wanted to fix some things up in the trunk, so I set up the databases and ran the unit tests. A bunch fail for postgres, and even more error out. I know of two postgresql adapters: postgres-pr and ruby-postgres. Strangely, they each fail different tests. So if I want to fix things up, which one should I be using? For that matter, which adapter should I be using for production? Finding out

Hello everyone. I''m starting with Rails going through the obvious "Getting Started with Rails" guide: http://guides.rubyonrails.org/getting_started.html Everything goes smoothly until the rake db:create command, which returns this strange error message referring to a gem that apparently doesn''t exist: Please install the postgresql adapter: `gem install activerecord-

A new release of the puppetlabs/postgresql module is now available on the Forge: https://forge.puppetlabs.com/puppetlabs/postgresql/2.1.0 Changelog ======== This release is primarily a feature release, introducing some new helpful constructs to the module. For starters, we''ve added the line `include ''postgresql_conf_extras.conf''` by default so extra parameters not

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.

Instead of using numeric I created the field "unit_price" as PostgreSQL type money. Now when I try and add a row I get the following. How do I override AR default behaviour to cast numeric post data to money, or am I forced to only support database types that active_record knows about? RuntimeError: ERROR C42804 Mcolumn "unit_price" is of type money but expression is of

Puppet 3.3.1 // CentOS release 6.4 (Final) rpm -qa | grep puppet puppetlabs-release-6-7.noarch puppet-3.1.1-1.el6.noarch puppetdb-1.3.0-1.el6.noarch puppet-server-3.1.1-1.el6.noarch puppetdb-terminus-1.3.0-1.el6.noarch Installed from yum packages: Running Transaction Installing : puppetdb-1.3.0-1.el6.noarch

After an afternoon wasted trying to install all of these stuff, I wrote an article, maybe it could be usefull for someone. http://cicolin.blogspot.com/ -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this

... to fix a problem with PostgreSQL reconnect after connection loss & put test coverage in place to keep it working in the future. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-core/-/EecNy-qyKwgJ. To post to this group, send email to

Hi i m very new in ruby ( i used to work on php) I am looking for good documentation or book which will show me how to use ruby with CGI + mysql /Postgresql something like, will show how to grab data from database and pass those into Select or combox box .. i tryed to look for books but i have not find any so good documentation site, books would be good Thnaks -- Posted via

Hello! I''ve submitted a patch to work around a problem when multiple schemas are included in the search_path in database.yml for PostgreSQL databases. (Long story short: the pg_dump --schema flag only accepts a single schema.) http://dev.rubyonrails.org/ticket/6665 While I''ve tested the regex pattern used to check for multiple schemas, I''m unsure of how to

Just joined the group. Please let me know if I am not posting this appropriately. I think the PR is done, just needs ok to merge and if it should be back-ported. I rebase if off our master periodically to ensure a clean merge. Re: https://github.com/rails/rails/pull/11148 Whereas - The code_statistics code in rails provides useful functionality - It does not depend on rails in any

Hey all, I''ve been eagerly following the development of 4.0 and 4.1, especially the Queue API, and have been running the `jobs` branch in production for a few projects. I know that one thing blocking progress for a 4.1 queue release is debate about what the interface should look like. Specifically, I know there were a few requests for an interface that allowed for namespacing

Need feedback on what I think is a bug in AR related to destroying models with optimistic locking. Please check this PR for more information: https://github.com/rails/rails/pull/9448 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To unsubscribe from this group and stop receiving emails from it, send an email to

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

I recently submitted a pull-request (https://github.com/rails/rails/pull/10939) to address a bug in PostgreSQLAdapter#disable_referential_integrity related to how the existing code behaves in a transaction when the PostgreSQL user account lacks superuser privileges on the PostgreSQL instance. While this permits the code to function without crashing, it doesn''t actually make

Hi! I have a table with visits with a visited_at: attribute which is a datetime field. They seem to be stored as UTC. Now I want to count all visits each day and return something like: { 2013-01-01: 8, 2013-01-02: 4, 2013-01-07: 9, ... } So, I did it like this which kind of works...: def self.total_grouped_by_day(start_date, end_date) visits = where(visited_at:

Hi all, i'' m trying to configure puppet to use rails with postgresql. I'' m having troubles to make it work. Got no error when running puppetmasterd but nothing is being populated in the DB. Is anybody using puppet with postgres ? my config (in puppet.conf) [rails] dbadapter = postgresql dbname = mydb dbserver = localhost dbuser = user dbpassword = password