Postgres Pro
Downloads
Home   >   mailing lists

Thread: drop enum problem

drop enum problem

From
Gavin Flower
Date:
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=>

Re: drop enum problem

From
John R Pierce
Date:
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 ....



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

Re: drop enum problem

From
Gavin Flower
Date:
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!  :-(