CODEWITHSUNDEEP
postgresqllaravelamazon-web-servicesamazon-ec2database-migration
abbood
abbood

Reputation: 23558

Does Amazon RDS have default setting on their postgresql?

Background

I have a laravel application that uses migration/seeding scripts that have always worked fine when ran on my localhost (OSX) and even on an AWS ec2 instance when the db is local.

Problem

The music started when I decided to connect the ec2 instance into a separate RDS instance (we're talking staging here), I ran my migration scripts as always, but then I got this rude error:

SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "users_type_check" of relation "users" does not exist (SQL: ALTER TABLE users DROP CONSTRAINT users_type_check;)

not sure why this is only happening on RDS, ideas?

Upvotes: 0

Views: 94

Answers (1)

Andy
Andy

Reputation: 1386

Agree with Vao's comment.

There is hardly anything RDS specific in that error message.

It seems you are under the impression that the user_type_check constraint is there, when in reality it may not.

You mentioned you are populating the database by running migrations, hence are you sure these have been ran and have populated the database correctly in the first place?

Upvotes: 1

Related Questions