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

From [email protected]
Subject BUG #6634: pg_dump dumps cast after objects depending on it
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: BUG #6634: pg_dump dumps cast after objects depending on it
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:      [email protected]
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