Re: Porting Schema from MySQL - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Porting Schema from MySQL
Date
Msg-id AD820326-833D-4E2E-8AE9-E08623A4B513@seespotcode.net
Whole thread Raw
In response to Porting Schema from MySQL  ("Farhan Khan" <farhankhan@google.com>)
List 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



pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
Next
From: "Scott Marlowe"
Date:
Subject: Re: Partitioned table limitation