From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | jose(dot)reyes(at)prswservices(dot)com |
Subject: | BUG #18700: pg_dump doesn't include definitions for collations nor types (e.g. enumeration) |
Date: | 2024-11-11 21:35:51 |
Message-ID: | 18700-838f37945e913cbd@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: 18700
Logged by: Jose Reyes
Email address: jose(dot)reyes(at)prswservices(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Haifang Wang (Centific Technologies Inc) | 2024-11-11 23:12:07 | RE: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |
Previous Message | Ľuboslav Špilák | 2024-11-11 17:11:13 | Re: Segmentation fault - PostgreSQL 17.0 |