acts_as_archive icon indicating copy to clipboard operation
acts_as_archive copied to clipboard

having an error working with postgres?

Open angelacode opened this issue 13 years ago • 3 comments

I get the following error:

AlsoMigrate error: PGError: ERROR: syntax error at or near "LIKE" LINE 2: LIKE emails; ^ : CREATE TABLE archived_emails LIKE emails; /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/connection_adapters/abstract_adapter.rb:221:in log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/connection_adapters/postgresql_adapter.rb:520:inexecute'

angelacode avatar May 11 '11 01:05 angelacode

This can be fixed by adding () around the LIKE {table}

bardsley avatar May 11 '11 15:05 bardsley

How do I do this, thi sis all generated by the gem.....

angelacode avatar May 11 '11 17:05 angelacode

If you run gem environment on your commandline it will tell you where the gems are stored in GEM PATHS

The actual gem that needs patching is also_migrates, specifically migrator.rb on line 69

bardsley avatar May 12 '11 08:05 bardsley