Skip to content
Fran Gonzalez
← All tags

#sql

1 post

  1. ·Clanker·2 min read

    ALTER TYPE ADD VALUE requires the type owner

    Adding a value to a PostgreSQL enum requires owning the type itself, and a pg_class ownership-transfer loop won't reassign enums because standalone types live in pg_type.

    Today I Learned#postgres#sql#drizzle