InflateColumn::DateTime doesn't understand "timestamp without timezone"

[Aleksey Mashanov]

Since revision r6221 (DBIx-Class 0.08103) InflateColumn::DateTime doesn't understand PostgreSQL's "timestamp without timezone" (as it's reported by database) type.

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Moritz Onken]

More important, what's your current version of  
InflateColumn::DateTime? Is it up to date?


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Андрей Костенко]

Yes, in the latest version exists this bug

On Wed, Jul 22, 2009 at 11:31 AM, Moritz Onken <[hidden email]> wrote:

More important, what's your current version of InflateColumn::DateTime? Is it up to date?


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Peter Rabbitson-2]

On Wed, Jul 22, 2009 at 12:15:29PM +0000, Андрей Костенко wrote:
> Yes, in the latest version exists this bug
>
> On Wed, Jul 22, 2009 at 11:31 AM, Moritz Onken <[hidden email]>wrote:
>
> > More important, what's your current version of InflateColumn::DateTime? Is
> > it up to date?
> >
> >

Are you *sure*? This commit [1] was specifically to fix this problem. If
you are having a problem still - we need more info - there is a working
test case for what you claim is broken.

[1]: http://dev.catalyst.perl.org/svnweb/bast/revision/?rev=6428


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Андрей Костенко]

timestamp without timezone

On Wed, Jul 22, 2009 at 12:24 PM, Peter Rabbitson <[hidden email]> wrote:

On Wed, Jul 22, 2009 at 12:15:29PM +0000, Андрей Костенко wrote:
> Yes, in the latest version exists this bug
>
> On Wed, Jul 22, 2009 at 11:31 AM, Moritz Onken <[hidden email]>wrote:
>
> > More important, what's your current version of InflateColumn::DateTime? Is
> > it up to date?
> >
> >

Are you *sure*? This commit [1] was specifically to fix this problem. If
you are having a problem still - we need more info - there is a working
test case for what you claim is broken.

[1]: http://dev.catalyst.perl.org/svnweb/bast/revision/?rev=6428

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Peter Corlett]

On Wed, Jul 22, 2009 at 11:28:38AM +0400, Aleksey Mashanov wrote:
> Since revision r6221 (DBIx-Class 0.08103) InflateColumn::DateTime doesn't
> understand PostgreSQL's "timestamp without timezone" (as it's reported by
> database) type.

I noticed this too, and created a dirty hack which works around the bug:

http://tripe.cabal.org.uk/archives/2009/07/dbic-note-to-self.html


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Peter Rabbitson-2]

On Wed, Jul 22, 2009 at 12:40:40PM +0000, Андрей Костенко wrote:
> timestamp *without* timezone

Mea culpa, misread your subject. Bug ash on IRC to fix it :)

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Андрей Костенко]

We have switched to "with timezone" :-)

On Wed, Jul 22, 2009 at 12:49 PM, Peter Corlett <[hidden email]> wrote:

On Wed, Jul 22, 2009 at 11:28:38AM +0400, Aleksey Mashanov wrote:
> Since revision r6221 (DBIx-Class 0.08103) InflateColumn::DateTime doesn't
> understand PostgreSQL's "timestamp without timezone" (as it's reported by
> database) type.

I noticed this too, and created a dirty hack which works around the bug:

http://tripe.cabal.org.uk/archives/2009/07/dbic-note-to-self.html

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Peter Rabbitson-2]

Aleksey Mashanov wrote:
> Since revision r6221 (DBIx-Class 0.08103) InflateColumn::DateTime
> doesn't understand PostgreSQL's "timestamp without timezone" (as it's
> reported by database) type.
>
>

Fixed as described in http://rt.cpan.org/Public/Bug/Display.html?id=48389

Cheers

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...