similar to: migrations questions: MySQL -> postgreSQL

Hello- I''m new to the ruby-based schemas and migrations. As I''m looking over examples and such online, I see that many of them don''t make use of schema-enforced attributes. For example, instead of: t.column "post_id", :integer, :default => 0, :null => false They do: t.column "post_id", :integer So I''m wondering -- is this

I need to call callback only if the validation was successful, but it seems it is called also when validation fails. -- Posted via http://www.ruby-forum.com/.

I''m using validates_format_of and the validation I want to do works, but I can''t get an error message to be displayed if the data is invalid: validates_format_of :mobile, :with => /\A[\+0-9]+\Z/, :message => " - Wrong" I have another validation some where else that does display the error message: " - Name is too long" validates_length_of :name,

Hi all. I have a problem with postgresql PK columns and ActiveRecord. The error is: PGError: ERROR: null value in column "item_id" violates not-null. Ok, it''s wrong to insert NULL into PK columns, but rails doing it. How to fix? So sad..

I''ve spent the last several months learning RoR and building my first app. I''ve not used migrations yet and honestly don''t understand them much, and have not had my app under version control. I''ve decided it''s time (I know, some will say way past time ;-) ) to put the app under version control. I''ll be using Subversion and have begun working

Ruby/Rails n00b here so go easy on me... I''ve been wracking my brain trying to figure out what is wrong here. I''ve checked all my models for the appropriate belongs_to, has_many, etc. I''ve checked to make sure I''m using singular and plurals in the right spot. I''ve checked my syntax around all my "within"''s and nothing seems to fix

I am new to ruby/rails and am having a problem with validates_length_of. It seems to work fine on a varchar field, but when I try it on a char field the extra characters are silently truncated and the message appears that the record was successfully updated. How can I get my app to produce my error message instead? I''ve tried various variations, but here''s one of my tries:

I am trying to make a barebones login system based on this example (which in turn is just standard RoR login) but when I enter a user name and password, it says the login is unsuccessful every time. I am not sure where I am going wrong. Here is all relevent information CREATE TABLE `users` ( `id` int(6) unsigned NOT NULL auto_increment, `login` varchar(20) NOT NULL default

Hi all, Short of hacking the code apart, is there a method making the login_engine authenticate against email address rather than username? I find that people rarely remember usernames, and would prefer to use email addresses as the identifier. Thanks! Tom

Thanks for the input Blair Zajac and Chris (Nolan and Hall), and for others. If all of you have time, please follow this (the question still relates to the previous posts by me): I have provided full steps to reproduce the symptoms. If it matters, I''m running Ruby 1.8.2, Rails 1.0, and MySQL 5.0.15 on Windows XP Professional. 1. First, the setup MySQL ----- create database testdb;

Hi I''d like to have a varchar primary key named id instead of the default int id. Does anyone knows how to specify this from migrations ? Should I also specify something in the model class ? thanks! Thibaut -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060312/797bca4b/attachment.html

I am new to Rails and Ruby. I''ve been a WebObjects developer for a few years and before that J2EE (shudder). I wanted to try RoR so I am porting an existing Web app. I am running the latest release on Tiger and PG8. Right now my single table has three attributes: id | integer | not null hotel_name | character varying(255) | not null hotel_location |

I read in various places that although migrations aren''t transactional, all you need to do is wrap you migration method in "ActiveRecord:: Base.connection.transaction do" to make the self.up or self.down transactional. In my experience (Rails + PostgreSQL), this doesn''t work very well. If my migration hits an exception, any tables that were touched remain modified.

Hi all, Rails 1.1.4 Rake 0.7.1 PostgreSQL 8.1.4 Windows XP Pro I checked for errata on pragmaticprogrammer.com, but didn''t see any explicit mention of this issue. I''m going over the depot example in AWDwR, 2nd ed, and I can''t get the migration to work on p. 82. Specifically, the AddTestData example (with reduced description text to save my fingers some typing):

I''ve tried tackling this many ways on my own and can''t find a good solution: Breaking it down to something simplier... Venue has one address Person has one address Address belongs to state Assuming I don''t want to do tables for venue_addresses and person_addresses. What is the best way to model this using rails... big thing here is i want to be able to reuse a

I''m new at this so please be patient. I have a very simple schema consisting of a around 10 tables in Postgresql. The aim is to provide a system for PC administrators to keep track of PC''s dotted around various venues (shops, libraries etc.). The sort of info I want to store is PC specs, PC network specs, PC ownership specs, PC location specs and contact person details. So I end

I''m running into the need (on at least one project now) to implement end-user-customizable "metadata" or properties on model objects. The standard example would be a Person class that had first_name, last_name, etc. but would need to be extended real-time (through the web admin interface) with properties such as phone_number : varchar (30). I''ve done some basic

I''ve created several different Rails applications but I''m running into the same trouble with each one. Lets say I create an app called Test. I type ''rails test'' and it generates the directory for me. Now I edit my database.yml file. Then I create a database with Postgresql by typing createdb test. Now I go into Postgresql by typing ''psql

Stupid activeldap is messing with my mind ;-) rails (3.1.1 activeldap (3.1.0) rubygems-update (1.4.2) I have activerecord (database.yml/postgresql) and activeldap (ldap.yml) as configured sources for my models. I want to add some more things to my models but activeldap is killing my attempts to create migrations... cwhite@nxpc:~/tti_framework$ rails generate migration AddSettings error

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class