Postgres Pro
Downloads
Home   >   mailing lists

Re: drop enum problem - Mailing list pgsql-bugs

From John R Pierce
Subject Re: drop enum problem
Date
Msg-id 4E7C0BC5.9080207@hogranch.com
Whole thread Raw
In response to drop enum problem  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Gavin Flower
Date:
Subject: drop enum problem
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6216: Calling PQconnectdbParams from C++ with a char**