Re: [BUGS] drop enum problem

[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" already exists
gavin=>


As soon as I saw this published, I saw my obvious mistake..

  DROP TYPE raindow;
                *
CREATE TYPE rainbow AS ENUM ...

Sory, but my eyesight is very bad, so I did not see the mistake 
initially!  :-(