Re: [BUGS] drop enum problem

2011-09-23 Thread Gavin Flower
On 23/09/11 10:43, Gavin Flower wrote: On a LInux 64 biut system: $ psql psql (9.1.0) Type "help" for help. gavin=> DROP TYPE raindow; ERROR: type "raindow" does not exist gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple'); ERROR: type "rainbow" alrea

Re: [BUGS] drop enum problem

2011-09-22 Thread John R Pierce
On 09/22/11 3:43 PM, Gavin Flower wrote: gavin=> DROP TYPE raindow; ERROR: type "raindow" does not exist gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple'); ERROR: type "rainbow" already exists PEBCAK. drop type rainDow create type rainBow --

[BUGS] drop enum problem

2011-09-22 Thread Gavin Flower
On a LInux 64 biut system: $ psql psql (9.1.0) Type "help" for help. gavin=> DROP TYPE raindow; ERROR: type "raindow" does not exist gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple'); ERROR: type "rainbow" already exists gavin=> -- Sent via pgsql-bu