Order in which tables are dumped
Hi,
v8.4 if it matters.
It looked like the tables were being backed up in alphanumeric order, but
now I see that table "docformat" is being dumped *after* "doc_image".
Are there some other rules besides alphabetical sorting?
--
Angular momentum makes the world go 'round.
Ron <ronljohnsonjr@gmail.com> writes:
It looked like the tables were being backed up in alphanumeric order, but
now I see that table "docformat" is being dumped *after* "doc_image".
Looks like standard C-locale (ASCII) sort order to me ...
Are there some other rules besides alphabetical sorting?
Dependencies can override the normal sort order, though a dependency
directly between two tables is rare.
regards, tom lane
On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr@gmail.com> wrote:
Hi,
v8.4 if it matters.
It looked like the tables were being backed up in alphanumeric order, but
now I see that table "docformat" is being dumped *after* "doc_image".Are there some other rules besides alphabetical sorting?
Is there some concern about the order? Lower case f comes after _ in ascii.
The only time it could possibly matter is on restore when there are
references for foreign keys, but on a restore those are all done after the
data is restored.
On 07/25/2018 10:28 AM, Tom Lane wrote:
Ron <ronljohnsonjr@gmail.com> writes:
It looked like the tables were being backed up in alphanumeric order, but
now I see that table "docformat" is being dumped *after* "doc_image".Looks like standard C-locale (ASCII) sort order to me ...
I hate spreadsheets. And gnu sort, and unicode... :(
--
Angular momentum makes the world go 'round.
On 07/25/2018 10:43 AM, Vick Khera wrote:
On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr@gmail.com
<mailto:ronljohnsonjr@gmail.com>> wrote:Hi,
v8.4 if it matters.
It looked like the tables were being backed up in alphanumeric order,
but now I see that table "docformat" is being dumped *after* "doc_image".Are there some other rules besides alphabetical sorting?
Is there some concern about the order? Lower case f comes after _ in ascii.
I'm tracking the progress of a very long backup, and the spreadsheet I using
(and gnu sort, too, and IIRC Postgres' own ORDER BY) sort based on the
current locale (en_US), whereas pg_dump sorts based on the C locale. Thus,
things aren't as I expected.
The only time it could possibly matter is on restore when there are
references for foreign keys, but on a restore those are all done after the
data is restored.
--
Angular momentum makes the world go 'round.