* domenica 22 gennaio 2006, alle 17:01, Maurizio Lemmo - Tannoiser scrive:
> I search a bit, and I found this: http://dev.rubyonrails.org/ticket/2257
On this subject, again, i tested this sql code:
CREATE OR REPLACE FUNCTION my_fix_time() RETURNS trigger AS '
BEGIN
new.created_at = current_timestamp;
return new;
END;
' language plpgsql;
CREATE TRIGGER my_fix_time_comment before insert on comments for each
row execute procedure my_fix_time();
CREATE TRIGGER my_fix_time_articles before insert on articles for each
row execute procedure my_fix_time();
That seems solve the created_at issue.
I share it because different from what suggested on dev.rubyonrails (I
guess it depends from postgres version)
It's a temporary solution, but better than update manually the entry in
the db... :)
HTH.
--
Maurizio - Tannoiser - Lemmo
Founder Member of ERLUG http://erlug.linux.it
-------------------------------------------------------------------------------
Veronica: God Lilly, I see the Prozac's working.
Lilly: High on life, Veronica Mars. I've got a secret. A good one.
-- Veronica Mars: 1x01
_______________________________________________
Typo-list mailing list
Typo-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/typo-list
