drop enum problem

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: drop enum problem
Date: 2011-09-22 22:43:45
Message-ID: 4E7BBA21.4050200@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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=>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gavin Flower 2011-09-23 04:30:33 Re: drop enum problem
Previous Message Tom Lane 2011-09-22 16:35:56 Re: [v9.2] make_greater_string() does not return a string in some cases