[DOCS] PATH no longer a part of 7.4?

[Dan Langille]

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/


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [DOCS] PATH no longer a part of 7.4?

[Tom Lane]

"Dan Langille" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [DOCS] PATH no longer a part of 7.4?

[Bruce Momjian]

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
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [DOCS] PATH no longer a part of 7.4?

[Dan Langille]

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 
, I suspect it is this:

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

The error he is getting is:

psql::34: NOTICE:  CREATE TABLE will create implicit sequence 
'path_pathid_seq' for SERIAL column 'path.pathid'
psql::34: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit 
index 'path_pkey' for table 'path'
psql::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/


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [DOCS] PATH no longer a part of 7.4?

[Tom Lane]

"Dan Langille" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [DOCS] PATH no longer a part of 7.4?

[Tom Lane]

"Dan Langille" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [DOCS] PATH no longer a part of 7.4?

[Dan Langille]

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

> "Dan Langille" <[EMAIL PROTECTED]> 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/


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])