Postgres problem with import
Reported by Jake Morrison | August 12th, 2008 @ 07:27 AM
Import is not working with an array of ActiveRecord instances (all I have tried so far).
The sequence generation is using the default base class code (sequence.nextval) instead of the Postgres version ("nextval('sequence')").
There is some code to do this in the lib/ar-extensions/import/postgresql.rb file, but it doesn't appear to be loaded.
The ./lib/ar-extensions/adapters/postgresql.rb in the gem is empty. Not sure if that is a problem.
Comments and changes to this ticket
-
Gary Blessington November 17th, 2008 @ 01:10 AM
See here: http://www.continuousthinking.co...
That will get the ("nextval('sequence')") running. However, postgres imports are still executing individual sql inserts when using import.
Please Login or create a free account to add a new comment.
You can update this ticket by sending an email to from your email client. (help)
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
ActiveRecord::Extension (aka ar-extensions) is a plugin to extend and
enhance the functionality of ActiveRecord. It starts by adding better
find support for ActiveRecord. It then adds mass data import
capabilities which are highly efficient and lastly it supports to_csv
functionality.
It also introduces a cool concept of creating easily extendable pieces
of ActiveRecord functionality, so developers don't have to understand
ActiveRecord internals or have the fear of breaking ActiveRecord
itself.
