Search Postgresql Archives

Re: Converting mysql "on update" to postgres "rule"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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,
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;

You are in a loop...

Use a trigger that put NEW.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?


<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux