Re: Date of creation and of change - Mailing list pgsql-sql

From Andreas Tille
Subject Re: Date of creation and of change
Date
Msg-id Pine.LNX.4.21.0008251655530.716-100000@wr-linux02.rki.de
Whole thread Raw
In response to Re: Re: Date of creation and of change  (hlefebvre <hlefebvre@lexbase.net>)
List pgsql-sql
On Fri, 25 Aug 2000, hlefebvre wrote:

> Tom Lane wrote:

> >         NEW.ChangedAt := now();
> > to prevent the system from reducing timestamp('now') to a constant
> > when the function is first executed.
> > 
> >                         regards, tom lane
> yep you're right :
You both are completely right.  Forget about my previous mail.  I made
a boring mistake and left the old state untouched.  Now it works.

By the way: Hwo can I prevent Access from warning me about the fact,
that "another user" (well it's the postgres server) has changed the
data set while I was edditing it?  (In general it's no problem, but
if I try two changes immediately the second change will be started
with this boring warning.)  But this is perhaps off topic in this
list ....

Kind regards and many thanks to you all
       Andreas.



pgsql-sql by date:

Previous
From: hlefebvre
Date:
Subject: Re: Re: Date of creation and of change
Next
From: hlefebvre
Date:
Subject: Re: Re: Date of creation and of change