Re: [BUGS] wrong timezone precision using plpythonu trigger

2010-10-12 Thread Peter Eisentraut
On mån, 2010-10-11 at 00:13 -0400, Tom Lane wrote: > It looks to me like this used to work and got broken by this patch: > http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3ab8b7fa6f9ac2fb04096f8860261dc42d59a570 > > which lobotomized plpython to not care about passing the right ty

Re: [BUGS] wrong timezone precision using plpythonu trigger

2010-10-10 Thread Tom Lane
maizi writes: > CREATE LANGUAGE plpythonu ; > CREATE FUNCTION wrong() RETURNS trigger AS $wrong$ > from mx import DateTime > TD['new']['modif_time'] = DateTime.now() > return 'MODIFY' > $wrong$ LANGUAGE plpythonu; > CREATE TABLE pb ( a TEXT, modif_time TIMESTAMP(0) WITHOUT TIME ZONE ) ; > CREA