BUG #6634: pg_dump dumps cast after objects depending on it - Mailing list pgsql-bugs

From avandras@gmail.com
Subject BUG #6634: pg_dump dumps cast after objects depending on it
Date
Msg-id E1SRkVQ-0005cw-OR@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6634: pg_dump dumps cast after objects depending on it  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6634
Logged by:          Andr=C3=A1s V=C3=A1czi
Email address:      avandras@gmail.com
PostgreSQL version: 9.1.3
Operating system:   Ubuntu 10.04.4 LTS
Description:=20=20=20=20=20=20=20=20

A cast, which transforms a composite type to timestamp without time zone, is
included in the regular backups of a database.=20=20
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.=20=20
This causes that the DB cannot be successfully restored, only with the help
of an additional patch file, which must be maintained by hand.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"
Next
From: Clay McClure
Date:
Subject: Re: BUG #6633: PL/Python build does not honor PYTHON on Mac OS X