Postgres Pro
Downloads
Home   >   mailing lists

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

From Mateus Cordeiro Inssa
Subject [ADMIN] 'C' function (spi?) for datetime UPDATE trigger - HOW?
Date
Msg-id 199808191608.NAA02557@blaublau.innova.com.br
Whole thread Raw
List pgsql-admin
Tree view 
  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@innova.com.br
mateus@einstein.innova.com.br

Wed Aug 19 13:08:43 EST 1998

pgsql-admin by date:

Previous
From: Terry Mackintosh
Date:
Subject: 'C' function (spi?) for datetime UPDATE trigger - HOW?
Next
From: Diab Jerius
Date:
Subject: pg_dump segv'ing