BUG #18700: pg_dump doesn't include definitions for collations nor types (e.g. enumeration)

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

Responses

Browse pgsql-bugs by date

  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