pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedPATH no longer a part of 7.4?
7+ messages / 3 participants
[nested] [flat]
* PATH no longer a part of 7.4?
@ 2004-02-10 14:38 Dan Langille <dan@langille.org>
0 siblings, 3 replies; 7+ messages in thread
From: Dan Langille @ 2004-02-10 14:38 UTC (permalink / raw)
To: pgsql-docs
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 15:09 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Dan Langille <dan@langille.org>
2 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2004-02-10 15:09 UTC (permalink / raw)
To: Dan Langille <dan@langille.org>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 15:35 Dan Langille <dan@langille.org>
parent: Dan Langille <dan@langille.org>
2 siblings, 2 replies; 7+ messages in thread
From: Dan Langille @ 2004-02-10 15:35 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-docs
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 15:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dan Langille <dan@langille.org>
2 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2004-02-10 15:42 UTC (permalink / raw)
To: Dan Langille <dan@langille.org>; +Cc: pgsql-docs
"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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 16:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dan Langille <dan@langille.org>
1 sibling, 0 replies; 7+ messages in thread
From: Tom Lane @ 2004-02-10 16:32 UTC (permalink / raw)
To: Dan Langille <dan@langille.org>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-docs
"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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 16:38 Dan Langille <dan@langille.org>
parent: Dan Langille <dan@langille.org>
1 sibling, 1 reply; 7+ messages in thread
From: Dan Langille @ 2004-02-10 16:38 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-docs
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PATH no longer a part of 7.4?
@ 2004-02-10 16:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dan Langille <dan@langille.org>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2004-02-10 16:45 UTC (permalink / raw)
To: Dan Langille <dan@langille.org>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-docs
"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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-02-10 16:45 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-10 14:38 PATH no longer a part of 7.4? Dan Langille <dan@langille.org>
2004-02-10 15:09 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-02-10 15:35 ` Dan Langille <dan@langille.org>
2004-02-10 16:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-10 16:38 ` Dan Langille <dan@langille.org>
2004-02-10 16:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-10 15:42 ` Tom Lane <tgl@sss.pgh.pa.us>
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