The following bug has been logged on the website:
Bug reference: 6634
Logged by: András Váczi
Email address: avandras(at)gmail(dot)com
PostgreSQL version: 9.1.3
Operating system: Ubuntu 10.04.4 LTS
Description:
A cast, which transforms a composite type to timestamp without time zone, is
included in the regular backups of a database.
There are several views utilizing this cast, but these are always listed
before the cast, therefore pg_restore or psql will issue an error instead of
creating the view.
This causes that the DB cannot be successfully restored, only with the help
of an additional patch file, which must be maintained by hand.