Re: [GENERAL] Converting mysql "on update" to postgres "rule"

[Rodrigo Gonzalez]

Edward Blake escribió:

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,


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;

data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

You are in a loop...

Use a trigger that put NEW.data3 - CURRENT_TIMESTAMP

ERROR:  infinite recursion detected in rules for relation "visit"

Any ideas?

I've tried multiple iterations of how to accomplish this and keep getting stuck. With the one above, postgres yells and says:

smime.p7s
Description: S/MIME Cryptographic Signature