problems with date

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: problems with date
Date: 2004-12-21 03:59:30
Message-ID: 41C79FA2.9070400@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2004-12-21 04:15:39 transactions in multiple action rules
Previous Message Postgres Learner 2004-12-20 21:43:24 weird run-times with pg_autovacuum