On 29 January 2011 18:52, Jeff Davis <pg...@j-davis.com> wrote: > On Fri, 2011-01-28 at 21:52 +0000, Thom Brown wrote: >> Also, how do you remove a range type which coincides with a system >> range type. For example: >> >> postgres=# CREATE TYPE numrange AS RANGE (SUBTYPE=interval, >> SUBTYPE_CMP=interval_cmp); >> CREATE TYPE >> postgres=# drop type numrange; >> ERROR: cannot drop type numrange because it is required by the database >> system >> >> Is this because I shouldn't have been able to create this type in the >> first place? > > The types are in two different schemas. It's just as though you created > a table called pg_class. > > To drop the one you created, do: > DROP TYPE public.numrange;
*facepalm* Of course. :) My bad. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
