Skip site navigation (1) Skip section navigation (2)

Re: Potential bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Vinett <james(at)imdstrading(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Potential bug
Date: 2002-04-19 14:42:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
James Vinett <james(at)imdstrading(dot)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

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-04-19 15:57:48
Subject: Bug #636: REFERENCES on Inherits Table
Previous:From: Tom LaneDate: 2002-04-19 14:37:56
Subject: Re: Upgrade to 7.1.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group