Rails - Mar 2006 - Fwd: [Ruby on Rails] #4112: PostgreSQL views not supported when dumping schema.rb file

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 <davidhh@wrath.rubyonrails.com>
Date: Mar 7, 2006 7:57 AM
Subject: [Ruby on Rails] #4112: PostgreSQL views not supported when
dumping schema.rb file
To: johnwilger@gmail.com


#4112: PostgreSQL views not supported when dumping schema.rb file
----------------------------------+-----------------------------------------
 Reporter:  johnwilger@gmail.com  |       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 Wilger
http://johnwilger.com

-----------
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