Skip site navigation (1) Skip section navigation (2)

Re: Date of creation and of change

From: Andreas Tille <tillea(at)rki(dot)de>
To: hlefebvre <hlefebvre(at)lexbase(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL SQL <pgsql-sql(at)hub(dot)org>
Subject: Re: Date of creation and of change
Date: 2000-08-25 14:59:59
Message-ID: Pine.LNX.4.21.0008251655530.716-100000@wr-linux02.rki.de (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-sql by date

Next:From: Renato De GiovanniDate: 2000-08-25 15:13:59
Subject: Re: weird structure
Previous:From: Andreas TilleDate: 2000-08-25 14:50:07
Subject: Re: Date of creation and of change

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group