add a value to an ENUM type - Mailing list pgsql-general

From Edoardo Panfili
Subject add a value to an ENUM type
Date
Msg-id 4A9FF439.8050109@aspix.it
Whole thread Raw
Responses Re: add a value to an ENUM type  (APseudoUtopia <apseudoutopia@gmail.com>)
List pgsql-general
I have an enum type
CREATE TYPE shapeName AS ENUM('rectangle','circle');

now I need another value: 'square'

the pg_type.oid of 'shapename is 16458

It works, but Is it safe to use this?
insert into pg_enum (enumtypid,enumlabel) VALUES('16458','square');

thank you
Edoardo

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: auto-increment in a view
Next
From: "Gauthier, Dave"
Date:
Subject: column level, uid based authorization to update columns