Subject: | timestamp in postgresql |
Date: | Thu, 30 Apr 2009 00:45:54 +0000 (GMT) |
To: | bug-Catalyst-Manual [...] rt.cpan.org |
From: | Philipp Wesche <phi1ipp [...] yahoo.com> |
In the appendix of the tutorial, e.g. currently at
http://search.cpan.org/~hkclark/Catalyst-Manual-5.7020/lib/Catalyst/Manual/Tutorial/Appendices.pod
there is a section that deals with migration to postgresql. There is a possibly recent section in "part 4: basic CRUD" of the tutorial about adding specific timestamp columns:
http://search.cpan.org/~hkclark/Catalyst-Manual-5.7020/lib/Catalyst/Manual/Tutorial/BasicCRUD.pod#Add_Datetime_Columns_to_Our_Existing_Books_Table
Under sqlite, the correct data type for the timestamp columns is integer, but for postgresql, it's timestamp. Currently, the tutorial does not refer to the migration of these columns at all (hence my guess that it's a recent addition), but an example should definitely be given.
Thank you.
Phil