Hacker News new | ask | show | jobs
by Icathian 1102 days 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!
2 comments
wojcikstefan 1102 days ago
Whew, good to know! Another point towards the `CHECK` constraint approach. Thanks! :)
link
ComputerGuru 1102 days ago
It 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.
link
Icathian 1102 days ago
Donno about a bug Id, but there were a couple mailing list discussions. Here: https://www.postgresql.org/message-id/flat/1376149.167526827...

Disclosure: I reported this particular bug. It was a fun one to run down.

link