Re: [BUGS] BUG #6634: pg_dump dumps cast after objects depending on it

2012-05-10 Thread Tom Lane
=?ISO-8859-1?B?QW5kcuFzIFbhY3pp?= avand...@gmail.com writes: Object list as pg_restore outputs (see error log below): That is not tremendously helpful. pg_dump should generally dump casts before views, and you have not provided any information that would tell why it's not doing so in this case.

[BUGS] BUG #6634: pg_dump dumps cast after objects depending on it

2012-05-08 Thread avandras
The following bug has been logged on the website: Bug reference: 6634 Logged by: András Váczi Email address: avand...@gmail.com PostgreSQL version: 9.1.3 Operating system: Ubuntu 10.04.4 LTS Description: A cast, which transforms a composite type to timestamp without

Re: [BUGS] BUG #6634: pg_dump dumps cast after objects depending on it

2012-05-08 Thread Tom Lane
avand...@gmail.com writes: 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