Skip site navigation (1) Skip section navigation (2)

Re: drop enum problem

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: drop enum problem
Date: 2011-09-23 04:30:33
Message-ID: 4E7C0B69.709@archidevsys.co.nz (view raw or flat)
Thread:
Lists: pgsql-bugs
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!  :-(


In response to

pgsql-bugs by date

Next:From: John R PierceDate: 2011-09-23 04:32:05
Subject: Re: drop enum problem
Previous:From: Gavin FlowerDate: 2011-09-22 22:43:45
Subject: drop enum problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group