Print out your Table object, see if that column was defined as you
expected by reflect()
On Aug 13, 2009, at 3:29 AM, Julien Cigar <jci...@ulb.ac.be> wrote:
>
> I just tried :
>
> datetime(2009, 13, 12, 10, 12, tzinfo=pytz.timezone('Europe/
> Brussels'))
>
> instead of :
>
> datetime(2009, 13, 12, 10, 12)
>
> .. but without success, still the same error ..
>
>
> On Thu, 2009-08-13 at 11:27 +0200, Julien Cigar wrote:
>> Hello,
>>
>> I'm using PostgreSQL / SQLAlchemy 0.5.5 and I build my Table objects
>> using the reflection feature :
>>
>> {{{
>> metadata = schema.MetaData()
>> metadata.reflect(bind=_engine)
>> }}}
>>
>> I have a table which has a timestamptz column and when I try to
>> insert a
>> (for example) datetime(2009, 13, 12, 10, 12) in it, it fails with the
>> following exception :
>>
>> <type 'exceptions.TypeError'>: can't compare offset-naive and
>> offset-aware datetimes
>>
>> I guess it's because one side has a tzinfo and the other not. When I
>> look at the documentation the constructor of
>> sqlalchemy.types.DateTime
>> has a "timezone" parameter which is False by default. However when I
>> look at the column, timezone is set to True:
>>
>> Column(u'effective', PGDateTime(timezone=True), table=<content>)
>>
>> which is correct.
>>
>> Any idea how could I resolve this annoying problem ? Is it possible
>> to
>> set a default timezone in SQLAlchemy, or do I need to derive a
>> concrete
>> subclass of datetime.tzinfo, and pass it to every datetime() object ?
>>
>> Thanks,
>> Julien
>>
> --
> Julien Cigar
> Belgian Biodiversity Platform
> http://www.biodiversity.be
> Université Libre de Bruxelles (ULB)
> Campus de la Plaine CP 257
> Bâtiment NO, Bureau 4 N4 115C (Niveau 4)
> Boulevard du Triomphe, entrée ULB 2
> B-1050 Bruxelles
> Mail: jci...@ulb.ac.be
> @biobel: http://biobel.biodiversity.be/person/show/471
> Tel : 02 650 57 52
>
> No trees were killed in the creation of this message.
> However, many electrons were terribly inconvenienced.
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
