Обсуждение: PATH no longer a part of 7.4?

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?

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

"Dan Langille" <dan@langille.org> writes:
> 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.

You don't?

regression=# select * from pg_type where typname = 'path';
 typname | typnamespace | typowner | typlen | typbyval | typtype | typisdefined | typdelim | typrelid | typelem |
typinput| typoutput | typreceive |  typsend | typalign | typstorage | typnotnull | typbasetype | typtypmod | typndims |
typdefaultbin| typdefault 

---------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+----------+-----------+------------+-----------+----------+------------+------------+-------------+-----------+----------+---------------+------------
 path    |           11 |        1 |     -1 | f        | b       | t            | ,        |        0 |       0 |
path_in | path_out  | path_recv  | path_send | d        | x          | f          |           0 |        -1 |        0
|             | 
(1 row)

            regards, tom lane

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)


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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/

"Dan Langille" <dan@langille.org> writes:
> Here is how this issue arose.  A user of [ 7.2.something ]
> is getting this error when creating a table named path.

Right, in 7.2 the rowtype for such a table would conflict with the
predefined type.

> 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).

In 7.3 and later there is no conflict, because the predefined type name
lives in the pg_catalog schema, which is not where user tables are
customarily created.

            regards, tom lane

"Dan Langille" <dan@langille.org> writes:
> Hmmm, for a 7.2 user, is there any solution?  Apart from "drop type
> path"?  We'd rather not rename the table.

Upgrade, or rename the path type to something else.  (Not sure if there
are any bad consequences of renaming the path type.  It'd probably be a
bad idea to do so if the database is making any actual use of the path
type, just because of potential confusion.)

            regards, tom lane

On 10 Feb 2004 at 11:32, Tom Lane wrote:

> "Dan Langille" <dan@langille.org> writes:
> > Here is how this issue arose.  A user of [ 7.2.something ]
> > is getting this error when creating a table named path.
>
> Right, in 7.2 the rowtype for such a table would conflict with the
> predefined type.
>
> > 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).
>
> In 7.3 and later there is no conflict, because the predefined type name
> lives in the pg_catalog schema, which is not where user tables are
> customarily created.

Hmmm, for a 7.2 user, is there any solution?  Apart from "drop type
path"?  We'd rather not rename the table.
--
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/