Re: [Dbix-class] Schema::Loader and views on Pg

2010-05-02 Thread Matt S Trout
On Sat, May 01, 2010 at 12:53:28PM -0700, Dorian Taylor (Lists) wrote: Hey guys, been a while... Welcome back. I have a Postgres (current) database that has a bunch of log tables. On top of those is a bunch of views that take the most recent record, basically going like: CREATE VIEW

Re: [Dbix-class] DynamicSubclass and Preview: conflict?

2010-05-02 Thread Matt S Trout
On Fri, Apr 30, 2010 at 09:57:11AM +0200, Miquel Ruiz wrote: Just to try to solve it in the testing code, i have moved the subclasses' extra columns to the parent class, but it is still not working: Just to make it clearer: the 'deleted' column which the error is complaining about is not

Re: [Dbix-class] inflate_results and source_name

2010-05-02 Thread Bill Moseley
On Thu, Apr 29, 2010 at 2:08 PM, Matt S Trout m...@shadowcat.co.uk wrote: source_name is a proxy through to the result_source_instance in class data. If you don't call __PACKAGE__-table(__PACKAGE__-table); in a subclass to get a new source, you don't have a new source. So you've just set

Re: [Dbix-class] Schema::Loader and views on Pg

2010-05-02 Thread Dorian Taylor (Lists)
On 2-May-10, at 12:59 PM, Matt S Trout wrote: Welcome back. Thanks! What about letting S::L pull the column names and then just setting the primary keys and adding rels as a fixup? I think what I'm going to do is make the current views into tables and then use triggers on the