Re: PATH no longer a part of 7.4?

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/