[GENERAL] plpython and current_timestamp / current_user

[Vitor Tortorello]

Hi.

1 - current_timestamp and current_user are not enable in plpython?

2 - About timestamp using plpython:
a.
   upd= strftime(''%Y-%m-%d %H:%M:%S'', localtime())
    TD["new"]["updated"]   = upd
psql:/tmp/insereusuario.sql:2: NOTICE:  ('2003-07-30 13:55:32',)
psql:/tmp/insereusuario.sql:2: ERROR:  TIMESTAMP(154) precision must be 
between 0 and 6

b.
    qsql = plpy.prepare("SELECT fqdn_id, user, now() AS upd FROM fqdns 
WHERE domain = $1", ["text"])
    qry = plpy.execute(qsql, [userdomain],1)

    plpy.notice(qry[0]["upd"])

    TD["new"]["updated"]   = qry[0]["upd"]

psql:/tmp/insereusuario.sql:2: NOTICE:  ('2003-07-30 13:58:23.19289-03',)
psql:/tmp/insereusuario.sql:2: ERROR:  TIMESTAMP(154) precision must be 
between 0 and 6

3. links to plpython manuals are welcome.

Thank you.

Vitor

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]