Hi,

having a small problem in a trigger i want to automatically update a date field but when i use for example

update table
set field = current_date
where table.pk = new.pk

or

update table
set field = now()
where table.pk = new.pk

this crashes think link between server and db, i have tried using these commands on a command line and they work ok

thanks for any help again

JD

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to