Converting mysql "on update" to postgres "rule"

From: "Edward Blake" <comedian(dot)watchman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Converting mysql "on update" to postgres "rule"
Date: 2008-03-25 18:51:05
Message-ID: eae776d40803251151t4ec96531ka5ba0976c064dba6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks to everyone who's helped me before.

I'm trying to create the following mysql table in postgres:

CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP);

Thus far, I've been able to get this far:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP);
CREATE RULE timestamp_update AS ON UPDATE TO visit
DO ALSO
UPDATE vist
SET data3 = CURRENT_TIMESTAMP;

I've tried multiple iterations of how to accomplish this and keep getting
stuck. With the one above, postgres yells and says:
ERROR: infinite recursion detected in rules for relation "visit"

Any ideas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-03-25 18:54:37 Re: select any table
Previous Message srdjan 2008-03-25 18:40:26 RULES and QUALIFICATION for INSERT