From: Dan Langille <dan@langille.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-docs@postgresql.org
Subject: Re: PATH no longer a part of 7.4?
Date: Tue, 10 Feb 2004 10:35:15 -0500
Message-ID: <4028B3E3.10865.19F6DF63@localhost> (raw)
In-Reply-To: <200402101509.i1AF9aa18540@candle.pha.pa.us>
References: <4028A69C.31201.19C2FF1E@localhost>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: dan@langille.org, pgman@candle.pha.pa.us
Subject: Re: PATH no longer a part of 7.4?
In-Reply-To: <4028B3E3.10865.19F6DF63@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox