X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 3C28AD1C7F7
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Tue, 10 Feb 2004 15:35:31 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 34905-03
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Tue, 10 Feb 2004 11:35:17 -0400 (AST)
Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150])
	by svr1.postgresql.org (Postfix) with ESMTP id 1F7CAD1DA5F
	for <pgsql-docs@postgresql.org>; Tue, 10 Feb 2004 11:35:13 -0400 (AST)
Received: from wocker (wocker.unixathome.org [192.168.0.99])
	by bast.unixathome.org (Postfix) with ESMTP
	id 040153D28; Tue, 10 Feb 2004 10:35:16 -0500 (EST)
From: "Dan Langille" <dan@langille.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Date: Tue, 10 Feb 2004 10:35:15 -0500
MIME-Version: 1.0
Subject: Re: PATH no longer a part of 7.4?
Cc: pgsql-docs@postgresql.org
Message-ID: <4028B3E3.10865.19F6DF63@localhost>
In-reply-to: <200402101509.i1AF9aa18540@candle.pha.pa.us>
References: <4028A69C.31201.19C2FF1E@localhost>
X-mailer: Pegasus Mail for Windows (v4.02a)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/9
X-Sequence-Number: 2264

On 10 Feb 2004 at 10:09, Bruce Momjian wrote:

> Dan Langille wrote:
> > The Geometric data types listed at 
> > http://www.postgresql.org/docs/current/static/datatype-geometric.html 
> > include a data type known as "path".  I do not see this data type in 
> > my 7.4 installation.
> > 
> > Which is wrong?  The documentation or the code?
> 
> It is in CVS:
> 	
> 	test=> \dT path
> 	                List of data types
> 	   Schema   |  Name  |        Description
> 	------------+--------+----------------------------
> 	 pg_catalog | "path" | geometric path '(pt1,...)'
> 	(1 row)

Ahhh yes, sorry, I was looking further down in the output of \dt 
instead of at the top where they appear in "quotes".  Thank you.

Here is how this issue arose.  A user of:

Suse SLES 8 (aka UnitedLinux 1.0), Postgres 7.2.4 according to the 
docs, however:

                                version
----------------------------------------------------------------------
--
 PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 
3.2.2

Is getting this error when creating a table named path.  I'm waiting 
for details on the exact create statement, but given the application 
<http://www.bacula.org/>, I suspect it is this:

create table path
(
    pathid            serial                not null,
    path              text                  not null,
    primary key (pathid)
);

The error he is getting is:

psql:<stdin>:34: NOTICE:  CREATE TABLE will create implicit sequence 
'path_pathid_seq' for SERIAL column 'path.pathid'
psql:<stdin>:34: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit 
index 'path_pkey' for table 'path'
psql:<stdin>:34: ERROR:  type named path already exists

We're confused.

I've been able to create this table under 7.4.1, 7.4, and 7.3.4 (but 
have no other versions under which I can test).

Thanks
-- 
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/