problems with date - Mailing list pgsql-general

From Jamie Deppeler
Subject problems with date
Date
Msg-id 41C79FA2.9070400@doitonce.net.au
Whole thread Raw
Responses Re: problems with date
List pgsql-general
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

pgsql-general by date:

Previous
From: Postgres Learner
Date:
Subject: weird run-times with pg_autovacuum
Next
From: Ron Peterson
Date:
Subject: transactions in multiple action rules