Re: Fix to enum hashing for dump and restore

2023-01-25 Thread Andrew
Those are excellent points. We will investigate adjusting pg_dump behavior, as this is primarily a dump+restore issue. Thank you! -Andrew J Repp (VMware) On Tue, Jan 24, 2023, at 9:56 PM, Tom Lane wrote: > Andrew writes: > > I have discovered a bug in one usage of enums. If a table with hash

Re: Fix to enum hashing for dump and restore

2023-01-24 Thread Tom Lane
Andrew writes: > I have discovered a bug in one usage of enums. If a table with hash > partitions uses an enum as a partitioning key, it can no longer be > backed up and restored correctly. This is because enums are represented > simply as oids, and the hash function for enums hashes that oid to >

Fix to enum hashing for dump and restore

2023-01-24 Thread Andrew
Hello, I have discovered a bug in one usage of enums. If a table with hash partitions uses an enum as a partitioning key, it can no longer be backed up and restored correctly. This is because enums are represented simply as oids, and the hash function for enums hashes that oid to determine partiti