Re: Potential bug

James Vinett <james@imdstrading.com> writes:
> ERROR:  TypeCreate: type bit already defined

This is neither a bug nor a keyword conflict.

A table has a datatype of the same name associated (the composite type
corresponding to its rowtype).  So, when you try to create table "bit"
that means creating type "bit" too.  But there already is one.

In 7.3 this issue will be considerably alleviated because the predefined
datatypes will live in a different schema (namespace) than user-defined
datatypes do.  But you'll still get burnt if you make a datatype "foo"
and then try to create a table "foo".

            regards, tom lane