--- Matt S Trout <[EMAIL PROTECTED]> wrote: > On Sat, May 26, 2007 at 08:30:29AM -0400, Jason > Kohles wrote: > > On May 23, 2007, at 8:04 PM, Tom Lanyon wrote: > > > > > > > >Jason, > > > > > >Just curious, what column type are you using that > includes > > >'timestamp' as well as other chars? > > > > > PostgreSQL has more than one timestamp type, which > may show up in the > > column_info as: > > > > timestamp with time zone > > timestamp without time zone > > timestamp > > timestamptz > > And none of those need special handling? > > Peopl who champion a specific DB engine, how would > this work for you? > > I'm getting increasingly tempted to just sod it and > apply jason's patch > when he sends out a test case or two for it and > we'll see what happens.
They do need tweaks to the timedate inflation/deflation but I usually do it by hand and not rely on the standard timedate inflators. I thought about offering a patch for this but to be honest it seems like it would get messy to have each inflator/deflator have to deal with each and every database issue. seems like something that should go into storage. I don't know who the Postgresql champion is, but if you don't have one I'll volunteer. My 2 cents is I don't object to the patch mentioned since most of the time it does what you want, unless you are doing fancy stuff with multiple timezones in the database. I typically normalize to GMT and then set a TZ offset as a table attribute for when I need to manage users or stuff in different timezones. --john > > -- > Matt S Trout Need help with your > Catalyst or DBIx::Class project? > Technical Director Want a managed development > or deployment platform? > Shadowcat Systems Ltd. Contact mst (at) > shadowcatsystems.co.uk for a quote > http://chainsawblues.vox.com/ > http://www.shadowcatsystems.co.uk/ > > _______________________________________________ > List: > http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class > Wiki: http://dbix-class.shadowcatsystems.co.uk/ > IRC: irc.perl.org#dbix-class > SVN: > http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ > Searchable Archive: > http://www.mail-archive.com/[email protected]/ > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
