also_migrate icon indicating copy to clipboard operation
also_migrate copied to clipboard

Postgres 8.4 error on rake db:migrate

Open dzaporozhets opened this issue 13 years ago • 3 comments

For postgres 8.4 sql like this "CREATE TABLE archived_articles LIKE articles" is invalid. This is correct one "CREATE TABLE archived_articles (LIKE articles)"

dzaporozhets avatar Apr 05 '11 11:04 dzaporozhets

I have the same, but on Postgres 9.0.3.

AlsoMigrate error: PGError: ERROR:  syntax error at or near "LIKE"
LINE 2:                       LIKE users;
                              ^
:                       CREATE TABLE archived_users
                      LIKE users;

kavu avatar Apr 07 '11 10:04 kavu

You can use my fork - https://github.com/randx/also_migrate

dzaporozhets avatar Apr 07 '11 10:04 dzaporozhets

Could you send a pull request to winton to resolve this. It's causing issues with connected gems like acts_as_archivable

bardsley avatar May 12 '11 09:05 bardsley