I just added a ticket to the Rails Trac about this issue. Is anyone
else here running into the same problem? If so, perhaps we can put our
heads together to come up with a workable solution.
---------- Forwarded message ----------
From: Ruby on Rails [email protected]
Date: Mar 7, 2006 7:57 AM
Subject: [Ruby on Rails] #4112: PostgreSQL views not supported when
dumping schema.rb file
To: [email protected]
#4112: PostgreSQL views not supported when dumping schema.rb file
----------------------------------±----------------------------------------
Reporter: [email protected] | Owner: David
Type: defect | Status: new
Priority: normal | Milestone:
Component: ActiveRecord | Version: 1.0.0
Severity: normal | Keywords: postgresql schema.rb
views
----------------------------------±----------------------------------------
If you use views in your PostgreSQL database, you cannot currently use
the
schema.rb file for testing, etc. It generates definitions for the
regular
tables, but nothing for the views. Even if no DSL to support views is
added to the AR Schema DSL, it would be nice if AR would at least
reflect
on the views and insert the necessary execute statements into the
schema.rb file.
Obviously, one hangup here would be trying to ensure that the order of
the
statements is correct, since you can’t create a view that depends on an
entity that doesn’t yet exist.
I’m willing to put in some work on fixing this, but I don’t have
anything
yet. I just wanted to get the issue reported in case anyone else is
running into the same issue.
–
Ticket URL: http://dev.rubyonrails.org/ticket/4112
Ruby on Rails http://dev.rubyonrails.org/
–
Regards,
John W.
Alice came to a fork in the road. “Which road do I take?” she asked.
“Where do you want to go?” responded the Cheshire cat.
“I don’t know,” Alice answered.
“Then,” said the cat, “it doesn’t matter.”
- Lewis Carrol, Alice in Wonderland