4 ms·
Little known bug, but enums also choke dump/restore if you use them as a hash partition key. That said, they can be really nice for all the same reasons static
by Icathian 3y ago
Little known bug, but enums also choke dump/restore if you use them as a hash partition key.
That said, they can be really nice for all the same reasons static types are nice. Good article!
- wojcikstefan 3y agoWhew, good to know! Another point towards the `CHECK` constraint approach. Thanks! :)
- ComputerGuru 3y agoIt sure sounds like a bug to me, too! Is there an upstream bug id? I’d imagine dump/restore should “just work” with anything that can be done in postgres oob.
- Icathian 3y agoDonno about a bug Id, but there were a couple mailing list discussions. Here: https://www.postgresql.org/message-id/flat/1376149.1675268279%40sss.pgh.pa.us https://www.postgresql.org/message-id/flat/1376149.167526827... Disclosure: I reported this particular bug. It was a fun one to run down.