Re: Porting Schema from MySQL

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "Farhan Khan" <farhankhan(at)google(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Porting Schema from MySQL
Date: 2007-10-01 20:17:49
Message-ID: AD820326-833D-4E2E-8AE9-E08623A4B513@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 1, 2007, at 14:54 , Farhan Khan wrote:

> Any pointer for implementing this functionality in postgresql ??

Write a trigger that fires on update and replaces the value with
CURRENT_TIMESTAMP.

You could probably do something like this with rules as well, but the
trigger method is probably more straightforward.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-01 20:22:14 Re: Partitioned table limitation
Previous Message Scott Marlowe 2007-10-01 20:14:02 Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username