Public bug reported:
>From PostgreSQL v10, the sequence object has altered, moving attributes such
>as "increment_by" and "min_value" to the pg_sequences catalog, rather than
>holding them in the sequence itself.
The rails package on Ubuntu 18.04 does not seem to have caught up with this.
The error was encountered using the community supported script to
migrate Trac projects to Redmine.
Error text given was:
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column
"increment_by" does not exist
LINE 1: ...sues_id_seq"', (SELECT COALESCE(MAX("id")+(SELECT increment_...
^
: SELECT setval('"public"."issues_id_seq"', (SELECT
COALESCE(MAX("id")+(SELECT increment_by FROM "public"."issues_id_seq"), (SELECT
min_value FROM "public"."issues_id_seq")) FROM "issues"), false)
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:561:in `migrate'
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:782:in `block (2
levels) in <top (required)>'
Caused by:
PG::UndefinedColumn: ERROR: column "increment_by" does not exist
LINE 1: ...sues_id_seq"', (SELECT COALESCE(MAX("id")+(SELECT increment_...
^
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:561:in `migrate'
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:782:in `block (2
levels) in <top (required)>'
Tasks: TOP => redmine:migrate_from_trac
** Affects: rails (Ubuntu)
Importance: Undecided
Status: New
** Tags: postgresql rails ruby
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1776931
Title:
ruby-rails 2:4.2.10 does not utilise PGSQL 10 sequence model
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/rails/+bug/1776931/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
