Received: from kop.maaco.com ([204.7.161.19]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA32938 for ; Thu, 27 May 1999 13:48:09 -0400 (EDT) (envelope-from aturner@maaco.com) Received: from maaco.com (204.7.161.134 [204.7.161.134]) by kop.maaco.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id LX8L69RW; Thu, 27 May 1999 13:43:34 -0400 Sender: root Message-ID: <374D8592.12DFE589@maaco.com> Date: Thu, 27 May 1999 13:49:06 -0400 From: Alex Turner Organization: Maaco Enterprises X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-interfaces@postgreSQL.org" Subject: Wierd error when creating a table... Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When I try to create a table where the primary key is set to be a column that is of type int8 or int28 it complains giving me the following error: ERROR: Can't find a default operator class for type 22. If I try to define the table again, it tells me that the relation already exists, yet it doesnt who up on the table list when I hit \d in psql. I also get the error if I try to define an index based on a field with one of those types. Is this a known bug, or am I trying to do something odd? TIA Alex T