Thank you.
2009/5/25, Ben Madin <[email protected]>: > 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 > > [email protected] > > > > Out here, it pays to > know... > > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
