Re: postgresql plpython bug

2005-05-05 Thread Mage
Jonathan Ellis wrote: > >First, you don't give enough context to see where your python code >generates a timestamp, but in any case it's more of a limitation than a >bug that plpython doesn't try to autoconvert certain datatypes. (Are >you even returning a datetime class, or a string?) > > I ga

Re: postgresql plpython bug

2005-05-04 Thread Jonathan Ellis
Mage wrote: > create or replace function trigger_keywords_maintain() returns trigger as $$ > return 'MODIFY' > $$ language plpythonu; > > update table set id = id where id = 7; > > ERROR: invalid input syntax for type timestamp: "2005-05-03 > 14:07:33,279213" > > I see that Python's timestamp

postgresql plpython bug

2005-05-04 Thread Mage
Hello! create or replace function trigger_keywords_maintain() returns trigger as $$ return 'MODIFY' $$ language plpythonu; update table set id = id where id = 7; ERROR: invalid input syntax for type timestamp: "2005-05-03 14:07:33,279213" I see that Python's timestamp format is n