Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0OF08l53678 for ; Thu, 24 Jan 2002 10:00:08 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0OF00f12627; Thu, 24 Jan 2002 10:00:00 -0500 (EST) To: "Felipe Nievinski" cc: pgsql-sql@postgresql.org Subject: Re: table name - TypeCreate error In-reply-to: References: Comments: In-reply-to "Felipe Nievinski" message dated "Thu, 24 Jan 2002 13:20:26 +0000" Date: Thu, 24 Jan 2002 10:00:00 -0500 Message-ID: <12624.1011884400@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/270 X-Sequence-Number: 6354 "Felipe Nievinski" writes: > I would expect to be able to create a table with any name different > than others tables' name. A table also implies a type (for its rowtype) in Postgres. Sorry. In 7.3 this will be less of a problem since user tables will live in a different schema than system types do. For now, there's nothing you can do except name your table something else. regards, tom lane