James Vinett <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly