Re: drop enum problem

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: drop enum problem
Date: 2011-09-23 04:32:05
Message-ID: 4E7C0BC5.9080207@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2011-09-23 05:05:21 Re: [BUGS] BUG #5206: wal_sync_method in stock postgresql.conf may be wrong
Previous Message Gavin Flower 2011-09-23 04:30:33 Re: drop enum problem