© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
If we use revision_date we need to cope with revision_dates in the future. At the moment it is possible to kill the feed by pushing 25 future revisions.
The simple fix is to add a WHERE revision_date <= CURRENT_TIMESTAMP clause, although then it is possible to add revisions that will never be seen in the feed then (a possible way of hiding trojans if we use this pattern elsewhere).