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
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? |