Re: [GENERAL] add a value to an ENUM type

2009-09-03 Thread Edoardo Panfili
On 03/09/09 22.13, APseudoUtopia wrote: On Thu, Sep 3, 2009 at 12:52 PM, Edoardo Panfili wrote: 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

Re: [GENERAL] add a value to an ENUM type

2009-09-03 Thread APseudoUtopia
On Thu, Sep 3, 2009 at 12:52 PM, Edoardo Panfili wrote: > 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

[GENERAL] add a value to an ENUM type

2009-09-03 Thread Edoardo Panfili
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 -- Sent via pgsql-gene