Thread

  1. wrong dump order in pg_dump for new data types

    PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-04-20T18:53:50Z

    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
    
    
    
  2. Re: wrong dump order in pg_dump for new data types

    Tom Lane <tgl@sss.pgh.pa.us> — 2001-04-20T19:43:45Z

    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