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).
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 |