I've been following online examples of how to create tables the Rails way
and I noticed the migration scripts I created containing references don't
work out of the box. I thought maybe I did something wrong so I tried just
now making a test application/migration against a *SQLite3* datasource. I
ran the following commands:
$ rails g scaffold SchoolClass name
$ rails g scaffold Student name SchoolClass:references
And it made my migration scripts (along with everything else).
<img src=’/uploads/default/original/2X/1/1d600dbb8c34ca43e53061bf69b32f46734ea8c8.png’ width=‘434’ height=‘190’>
I ran the migration scripts and it worked fine.
<img src=’/uploads/default/original/2X/3/30bdd3960220c5860f6110934876781407f8a124.png’ width=‘400’ height=‘187’>
When I tried doing the same steps above against a *Postgres* datasource, I
kept on getting the following:
PG::UndefinedTable: ERROR: relation does not exist
The only way I got past this issue is if I went into the migration script
and updated the t.references line and replaced the class name with the
actual table name. It's a simple enough fix, but I've got a ton of tables
to migrate and each table can have a good number of references. Has anyone
seen this before, and is there some way to keep on using the scaffold
utility to make migrations?
Appreciative of any useful assistance,
If you type "Google" into Google, you can break the Internet. -- Jen Barber