having an error working with postgres? #30

Open
angelacode opened this Issue May 11, 2011 · 3 comments

Projects

None yet

2 participants

@angelacode

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'

@bardsley

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

@angelacode

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

@bardsley

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

@rrw4 rrw4 added a commit to rrw4/also_migrate that referenced this issue Dec 9, 2013
@rrw4 rrw4 Add parentheses around LIKE {table} per winton/acts_as_archive#30 52c390d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment