Skip Menu |

This queue is for tickets about the Catalyst-Manual CPAN distribution.

Report information
The Basics
Id: 45575
Status: resolved
Priority: 0/
Queue: Catalyst-Manual

People
Owner: HKCLARK [...] cpan.org
Requestors: phi1ipp [...] yahoo.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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
Should be addressed in this update revision: http://dev.catalystframework.org/svnweb/Catalyst/revision/?rev=9998 Will post a new version of Cat::Man soon.