Brion Vibber wrote:
Greg Sabino Mullane wrote:
For what it's worth, if you use MediaWiki with a Postgres database, dates *are* stored as true timestamp fields. The only big problem I found when converting them over was with the archive table, which still needs to at least emulate a char(14) due to the URLs generated within the code.
Er... no?
If it looks like it does, that's a bug in Special:Undelete and should be fixed.
Specifically, it should be using wfTimestamp( TS_MW, $blah ) rather than just spitting out timestamp field values into URLs directly.
-- brion vibber (brion @ pobox.com)