Skip site navigation (1) Skip section navigation (2)

Patch: Allocation of "kind" codes for spatial type.

From: Ale Raza <araza(at)esri(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Paul Ramsey" <pramsey(at)refractions(dot)net>, "John Baleja" <jbaleja(at)esri(dot)com>
Subject: Patch: Allocation of "kind" codes for spatial type.
Date: 2007-05-08 15:41:16
Message-ID: 7CAD6D9B7D16BC4A88795771E486508205C7C80B@pianowire.esri.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom,

Attached is the modified pg_statistic.h file for this patch. As you
mentioned 200 - 299 is reserved for ESRI st_geometry type. Out of these
values I am using code 200 for st_geometry. 

Related threads for this patch:
http://archives.postgresql.org/pgsql-hackers/2007-05/msg00043.php
http://archives.postgresql.org/pgsql-general/2007-04/msg01075.php


Thanks.

Ale.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Friday, May 04, 2007 10:18 AM
To: Paul Ramsey
Cc: Ale Raza; pgsql-hackers(at)postgresql(dot)org; John Baleja; PostGIS
Development Discussion
Subject: Re: [HACKERS] Where to find kind code for STATISTIC_KIND
GEOMETRY? 

Paul Ramsey <pramsey(at)refractions(dot)net> writes:
> Just take 150-199, and submit a patch to HACKERS to updates the
comment 
> in pg_statistic appropriately. I am sure the it will be some time
before 
> we invent another 49 kinds of selectivity statistic.

I've been on the wrong wavelength in this whole thread --- I thought the
OP wanted to know about some existing "kind" value used by PostGIS.  If
he's asking to be allocated some new "kind" values for code he intends
to write, I have no problem with giving him 200-299 ... it's not like
we seem to be in any danger of running out.  But please do submit a
patch in the style of the existing pg_statistic.h comments, showing who
controls those numbers and where they will be documented.

			regards, tom lane


Attachment: pg_statistic.h
Description: application/octet-stream (9.2 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2007-05-08 15:54:54
Subject: Re: Managing the community information stream
Previous:From: Zeugswetter Andreas ADI SDDate: 2007-05-08 15:13:37
Subject: Re: Seq scans roadmap

pgsql-patches by date

Next:From: Peter EisentrautDate: 2007-05-08 16:34:15
Subject: Re: small patch for guc issues
Previous:From: Tom LaneDate: 2007-05-08 15:02:41
Subject: Re: [HACKERS] Behavior of GENERATED columns per SQL2003

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group