Thread: wrong dump order in pg_dump for new data types

Harald Bartel (harald.bartel@prozentor.de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
wrong dump order in pg_dump for new data types

Long Description
Version: PostgreSQL 7.1
System: Debian Woody, both Linux 2.2.14 and 2.4.3

The problem occurs for new data types:
When pg_dump is called, sometimes the CREATE TYPE is dumped before
input/output functions are dumped. This makes a restore impossible.

Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> The problem occurs for new data types:
> When pg_dump is called, sometimes the CREATE TYPE is dumped before
> input/output functions are dumped. This makes a restore impossible.

I believe this was fixed about two weeks ago.  Are you sure you are
using 7.1 final release, not some beta version?

            regards, tom lane