BUG #8215: pg_dump includes table out of order in SQL dump

From: ijmorlan(at)uwaterloo(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8215: pg_dump includes table out of order in SQL dump
Date: 2013-06-06 16:00:15
Message-ID: E1Ukcbn-0003LY-Lo@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8215
Logged by: Isaac Morland
Email address: ijmorlan(at)uwaterloo(dot)ca
PostgreSQL version: 9.2.4
Operating system: Server: Ubuntu 12.04; Client: Mac OS X 10.5.8
Description:

My understanding is that pg_dump is supposed to include tables in SQL dumps
in alphabetical order by table name. If this is wrong then this bug may be
invalid and I apologize.

In a dump of a particular schema, I'm getting a particular table always
coming first. Renaming it to other names does not affect its placement in
the output. By contrast, renaming other tables does change their location
in the resulting output.

I've tried a few things to try to figure out what might be different about
the problem table with no success so far.

This is a schema-only dump (--schema-only).

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2013-06-06 20:17:48 Re: BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica
Previous Message Rafał Rzepecki 2013-06-06 14:24:26 Re: BUG #8198: ROW() literals not supported in an IN clause