I am using Laravel 5.3. I can connect successfully to my Redshift database.
However I discovered that the Laravel migrations feature does not work with Redshift because Laravel creates a 'migration' table within the schema which has a 'serial' type column. Redshift does not support the 'serial' type.
[Illuminate\Database\QueryException]
SQLSTATE[0A000]: Feature not supported: 7 ERROR: Column "migrations.id" has unsupported type "serial". (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))[PDOException]SQLSTATE[0A000]: Feature not supported: 7 ERROR: Column "migrations.id" has unsupported type "serial".
Is there anyway around this so that I can use migrations with Redshift?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire