From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jose.reyes@prswservices.com
Subject: BUG #18700: pg_dump doesn't include definitions for collations nor types (e.g. enumeration)
Date: Mon, 11 Nov 2024 21:35:51 +0000
Message-ID: <18700-838f37945e913cbd@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18700
Logged by: Jose Reyes
Email address: jose.reyes@prswservices.com
PostgreSQL version: 16.3
Operating system: Windows 11 24H2
Description:
While importing a whole database created with pg_dump (Windows Pg 16.3 and
PgAdmin 4 environment) to a Docker postgres:16.4-alpine3.20 container with
no data, the pg_restore command did not create any tables that used custom
collations or types. The import did not work with a Custom dump, and when I
tried with a Plain dump I examined the SQL it produced an couldn't find any
statements to create either collations nor types.
I scoured the PgAdmin 4 and pg_dump documentation and found no mention of
these classes. Ended up working around it by inserting the SQL required for
the tasks.
Please look into this and let me know, as I'm somewhat surprised I haven't
found anything on the internet about this specific situation.
Thanks,
Jose
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, jose.reyes@prswservices.com
Subject: Re: BUG #18700: pg_dump doesn't include definitions for collations nor types (e.g. enumeration)
In-Reply-To: <18700-838f37945e913cbd@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox