
Migration failing on PostgreSQL
Reported by Chris Barnett | August 31st, 2009 @ 01:34 PM
engines/adva_cms/db/migrate/20090709111934_add_email_notification_to_site.rb has:
add_column :sites, :email_notification, :boolean, :default => 0
Which fails under PostgreSQL:
== AddEmailNotificationToSite: migrating =====================================
-- add_column(:sites, :email_notification, :boolean, {:default=>0})
rake aborted!
An error has occurred, this and all later migrations canceled:
PGError: ERROR: column "email_notification" is of type boolean but default expression is of type integer
HINT: You will need to rewrite or cast the expression.
: ALTER TABLE "sites" ALTER COLUMN "email_notification" SET DEFAULT 0
The attached patch replaces :default => 0 with :default => false
Comments and changes to this ticket
-
Marko Seppä November 23rd, 2009 @ 05:25 PM
- State changed from new to resolved
Hi Chris,
sorry for late answer. Seems like this one has already applied to adva-cms master.
Thanks for the contribution,
-- Marko
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<p>Cutting edge cms, blog, wiki, forum ... plattform.</p>
<p>Find the code on <a href="http://github.com/svenfuchs/adva_cms/tree/master">GitHub: adva cms</a></p>
<p>Part of the business application framework <a href="http://www.advabest.org/">adva best</a>.</p>