[postgis-users] ST_NumPoints

[Ben Madin]

G'day,

This may be way off your problem, and in fact may not matter at all,  
but I am led to believe that :

On 21/05/2009, at 4:39 PM, Kis János Tamás wrote:

> I have a big table (with 21000 rows):
>
> CREATE TABLE kecskemet_k.foldreszletek
> ( sorszam bigserial NOT NULL,
>  hrsz text,
>  geometria geometry --POLYGON
> ) WITH (OIDS=TRUE);
> CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek
> USING gist (geometria);


1. it is better practice to add the geometry column to the table after  
generating the table using the postgis addGeometryColumn() function.
2. you may be better to add a gid column than using OIDS

So your table creation might end up looking like :

CREATE TABLE kecskemet_k.foldreszletek
( gid serial unique,
  sorszam bigserial NOT NULL,
  hrsz text
);

SELECT  
AddGeometryColumn 
('kecskemet_k','foldreszletek','geometria',-1,'POLYGON',2);

CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek
USING gist (geometria);

I hope this is correct and not unhelpful.

cheers

Ben

-- 

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au



							Out here, it pays to know...