Project

General

Profile

Actions

Defect #2343

closed

plugin migrations fails on postgresql 8.3

Added by francesco brunetti about 16 years ago. Updated almost 16 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
2008-12-15
Due date:
% Done:

0%

Estimated time:
Resolution:
Wont fix
Affected version:

Description

running a plugin migration on redmine 0.8 rc against a postgresql 8.3 db lead to the following error:

PGError: ERROR: integer out of range
: UPDATE plugin_schema_info
SET version = 20081215132719
WHERE plugin_name = 'the_plugin_im_working_on'

changing version column data type from integer to bigint fixes the problem

Actions #1

Updated by Jean-Philippe Lang about 16 years ago

Engines plugin was designed to work with 3-digits migration numbers (like Rails was used to).
Eg: 001_my_first_migration.rb

I'll see what can be done. But for now, you should name your plugin migrations this way.

Actions #2

Updated by Eric Davis about 16 years ago

See this forum thread for another reason to use incrementing migration numbers with Plugins (for now): http://www.redmine.org/boards/2/topics/show/2863

Actions #3

Updated by Jean-Philippe Lang almost 16 years ago

  • Status changed from New to Closed
  • Resolution set to Wont fix
Actions

Also available in: Atom PDF