Forum: Ruby on Rails Fwd: #4112: PostgreSQL views not supported when dumping sche

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
John W. (Guest)
on 2006-03-07 18:03
(Received via mailing list)
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 <removed_email_address@domain.invalid>
Date: Mar 7, 2006 7:57 AM
Subject: [Ruby on Rails] #4112: PostgreSQL views not supported when
dumping schema.rb file
To: removed_email_address@domain.invalid


#4112: PostgreSQL views not supported when dumping schema.rb file
----------------------------------+-----------------------------------------
 Reporter:  removed_email_address@domain.invalid  |       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.
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
This topic is locked and can not be replied to.