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 gave

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

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 format is