Rails database from MySQL to Postgres

Question

I developed a ROR application using MySQL and now want it to use Postgres instead.

I've used Navicat to data transfer the MySQL database to Postgres, and updated the database.yml with the Postgres environment settings.

When I run the ROR application, and try and login or create a user, I get the following error:

RuntimeError: ERROR C23502 Mnull value in column "id" violates not-null constraint FexecMain.c L2229 RExecConstraints: INSERT INTO "users

Thank you

bobince · Accepted Answer · 2010-02-14 13:34:34Z

2

Sounds like you had an AUTO_INCREMENT id column in your MySQL database. This is a non-ANSI-standard feature, so it won't necessarily work on other databases.

To do the same on Postgres you could use a SERIAL column type (or an equivalent explicit SEQUENCE).

answered Feb 14, 2010 at 13:34

bobince

538k111 gold badges675 silver badges846 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RewbieNewbie Over a year ago

How do I fix this, Is it something in the code I need to change or in the database, or both? Thank you

RewbieNewbie Over a year ago

This worked: ALTER TABLE users ALTER COLUMN id set DEFAULT NEXTVAL('users_id_seq')

Collectives™ on Stack Overflow

Rails database from MySQL to Postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related