Technology Errors

“Multiple Default Values” Migration Error with PostgreSQL 8.2.5

PostgreSQL 8.2.5 error == CreateHeartrates: migrating ================================================ — create_table(:heartrates) NOTICE: CREATE TABLE will create implicit sequence “heartrates_id_seq” for serial column “heartrates.id” rake aborted! PGError: ERROR: multiple default values specified for column “id” of table “heartrates” : CREATE TABLE heartrates (“id” serial primary key DEFAULT NULL, “user_id” integer DEFAULT NULL, “timestamp” timestamp with time zone DEFAULT…

Technology Insights

View for Version Numbers, Hostnames, IPs, Etc.

Here’s some code (and rendered view) for various version numbers, host names, IPs for Ruby, Rails, PostgreSQL, SMTP. <b>Network</b><br> UNIX hostname: <code><%= `hostname` %></code><br> SERVER_ADDR: <code><%= request.env[“SERVER_ADDR”].to_s %></code> <br> HOST_NAME : <code><%= request.host %></code> <br> REMOTE_ADDR: <code><%= request.env[“REMOTE_ADDR”].to_s %></code> <br> <br> <b>Software</b><br> Database: <code><%= ActiveRecord::Base.connection.select_value(“SELECT  VERSION()”) %></code><br> Email delivery method: <code><%= ActionMailer::Base.delivery_method %></code><br> SMTP server:…

Technology Insights

Making (and Verifying) the Migration to PostgreSQL in Rails

Install After installing PostgreSQL on Windows, I converted my Rails application from MySQL to PostgreSQL with the following steps: Create a new database in PostgreSQL Installed postgres-pr gem (Ruby driver) because the postgres gem (native driver) didn’t work. Will figure out why later on. Changed the appropriate Rails config stuff in database.yml development: adapter: postgresql…