[ADMIN] 'C' function (spi?) for datetime UPDATE trigger - HOW?

From: Mateus Cordeiro Inssa <mateus(at)einstein(dot)innova(dot)com(dot)br>
To: pgsql-admin(at)postgreSQL(dot)org
Cc: mateus(at)einstein(dot)innova(dot)com(dot)br
Subject: [ADMIN] 'C' function (spi?) for datetime UPDATE trigger - HOW?
Date: 1998-08-19 16:08:51
Message-ID: 199808191608.NAA02557@blaublau.innova.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm having problems with triggers that need to change datetime
values. If the trigger returns OK, the datetime field will be saved
correctly, but if I return [ array get NEW ] (trigger in Tcl) the
datetime "gain" 2 hours.
If I do an "elog NOTICE $NEW(field1)" it prints the correct value,
but if I do an "spi_exec -array ax "select '$NEW(field1)'::datetime",
again, the datetime "gain" 2 hours.
Any idea ? (Using Postgres 6.3.2 all patches on Linux 2.0.29).

Mateus Cordeiro Inssa
---------------------
Innova Producoes Digitais
---------------------
Linux User: 76186
ICQ (KXicq): 15243895
---------------------
mateus(at)innova(dot)com(dot)br
mateus(at)einstein(dot)innova(dot)com(dot)br

Wed Aug 19 13:08:43 EST 1998

Browse pgsql-admin by date

  From Date Subject
Next Message Diab Jerius 1998-08-19 16:12:06 pg_dump segv'ing
Previous Message Terry Mackintosh 1998-08-19 15:14:11 'C' function (spi?) for datetime UPDATE trigger - HOW?