On Mon, July 9, 2007 18:03, Chris Hapgood wrote:
> I don't think work has stalled, but there was a big chunk being brewed by
> Saimon.  I haven't heard from him in a while, so I'm not sure what is
> happening.
>
> Saimon?
>


I tried again with this product and I am not getting anywhere.  I created
a fresh rails project called tg and installed the globalize plugin for-1.2
therein.  This time, instead of running rake globalize:setup I created a
migration using script/generate globalize.  Now when I run the migration
(rake db:migrate) I get this:

$ rake db:migrate --trace
(in /home/byrnejb/software/tg)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
== GlobalizeMigration: migrating
==============================================
-- create_table(:globalize_countries, {:force=>true})
NOTICE:  CREATE TABLE will create implicit sequence
"globalize_countries_id_seq" for serial column "globalize_countries.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"globalize_countries_pkey" for table "globalize_countries"
   -> 0.0280s
-- add_index(:globalize_countries, :code)
   -> 0.0047s
-- create_table(:globalize_translations, {:force=>true})
NOTICE:  CREATE TABLE will create implicit sequence
"globalize_translations_id_seq" for serial column
"globalize_translations.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"globalize_translations_pkey" for table "globalize_translations"
   -> 0.0206s
-- add_index(:globalize_translations, [:tr_key, :language_id])
   -> 0.0213s
-- add_index(:globalize_translations, [:table_name, :item_id,
:language_id],
{:name=>"globalize_translations_table_name_and_item_and_language"})
   -> 0.0049s
-- create_table(:globalize_languages, {:force=>true})
NOTICE:  CREATE TABLE will create implicit sequence
"globalize_languages_id_seq" for serial column "globalize_languages.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"globalize_languages_pkey" for table "globalize_languages"
   -> 0.0285s
-- add_index(:globalize_languages, :iso_639_1)
   -> 0.0049s
-- add_index(:globalize_languages, :iso_639_2)
   -> 0.0048s
-- add_index(:globalize_languages, :iso_639_3)
   -> 0.0042s
-- add_index(:globalize_languages, :rfc_3066)
   -> 0.0046s
rake aborted!
PGError: ERROR:  currval of sequence "globalize_countries_id_seq" is not
yet defined in this session
: SELECT currval('globalize_countries_id_seq')
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
`log'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:152:in
`execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:433:in
`select'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in
`select_one'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in
`select_value'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:429:in
`last_insert_id'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:138:in
`insert'
./db/migrate//001_globalize_migration.rb:84:in `load_from_csv'
/usr/lib/ruby/1.8/csv.rb:560:in `each'
./db/migrate//001_globalize_migration.rb:78:in `load_from_csv'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:867:in
`silence'
./db/migrate//001_globalize_migration.rb:72:in `load_from_csv'
./db/migrate//001_globalize_migration.rb:57:in `real_up'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`send'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`migrate'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in
`migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in
`migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:330:in
`each'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:330:in
`migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:297:in
`up'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:288:in
`migrate'
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:4
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke'
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
`standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7
/usr/bin/rake:16:in `load'
/usr/bin/rake:16

Is this product simply MySQL specific at the moment and just cannot be
used with PostgreSQL?

--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@...
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3