Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My small but annoying problem is that the regular backups of a database of ours always list the user-defined casts after those views that would make use of them. For this reason I have to maintain a post-backup healing patch or whatever with the definition of quite a few objects depending on these casts (and, of course, depending on objects depending on ...). This seems to me sub-ideal :) but looking for a solution gave no results so far. Any help or hint will be highly appreciated.

The engine is PostgreSQL 9.1.3 but we observed the same behaviour with previous versions as well. The same error we get either running psql on 'plain' dumps or pg_restore on other types.

On a_horse_with_no_name's suggestion I've reported this on pgsql-bugs.

share|improve this question

closed as too localized by Jack Douglas May 9 '12 at 14:10

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Could you show us an example to reproduce the problem? Otherwise it's hard to help you. – Frank Heikens May 8 '12 at 18:15
Would I be correct to assume that the problematic casts are all casts that you've created using create cast ...? – gsiems May 8 '12 at 19:46
@Frank: it would be pretty hard to prepare a meaningful subset of the DB in question still producing the error. I've reported the bug on the pgsql-bugs list. After moderation there will be more details, but still no schema definition. Edited the question accordingly. – dezso May 9 '12 at 8:42
@gsiems: yes, you're right. – dezso May 9 '12 at 8:43
unless you can "provide a concrete example." here too we'll have to keep the question closed as it is unlikely to help anyone else – Jack Douglas May 9 '12 at 14:10