wrong dump order in pg_dump for new data types

Started by PostgreSQL Bugs Listalmost 25 years ago2 messagesbugs

pgsql-bugs@postgresql.org

almost 25 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

almost 25 years ago

In reply to: PostgreSQL Bugs List (#1)

Re: wrong dump order in pg_dump for new data types

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