Received: from www.aldratech.com ([213.157.162.9]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0ODZbl29405 for ; Thu, 24 Jan 2002 08:35:38 -0500 (EST) (envelope-from radu.popescu@aldratech.com) Subject: Re: table name - TypeCreate error From: Radu-Adrian Popescu To: Felipe Nievinski Cc: psql In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.1 Date: 24 Jan 2002 15:37:43 +0200 Message-Id: <1011879463.3343.51.camel@rpopescu> Mime-Version: 1.0 Received: from rpopescu ([192.168.0.6]) by mail.aldratech.com (JAMES SMTP Server 1.2.1rc2) with SMTP ID 173; Thu, 24 Jan 2002 15:35:30 +0200 X-Archive-Number: 200201/269 X-Sequence-Number: 6353 On Thu, 2002-01-24 at 15:20, Felipe Nievinski wrote: > Hi. > > Please, I would like to know why I can't create a table with a name > equal of a type name. > > For example, when a try this: > CREATE TABLE time (id int); > I get the following error message: > ERROR: TypeCreate: type time already defined > > I would expect to be able to create a table with any name different > than others tables' name. > > Thank you in advance, > Felipe. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org teamsheet=# CREATE TABLE "time" (id int); ERROR: type named time already exists teamsheet=# CREATE TABLE "Time" (id int); CREATE :-) -- Radu-Adrian Popescu CSA, DBA, Programmer