Database Reference
In-Depth Information
)
WITH (
OIDS=FALSE
);
Hereagain,wemaintainourconstraintssuchas
PRIMARY KEY
andspecifythegeo-
metry type (
MultiLineStringZM
), not because these will propagate to the child
tables,butforanyclientsoftwareaccessingtheparenttabletoanticipatesuchcon-
straints.
Nowwemaybegintocreatetablesthatinheritfromourparenttable.Intheprocess,
we will create a
CHECK
constraint specifying the limits of our associated geometry
using the following query:
CREATE TABLE chp02.contour_N2260630
(CHECK
(ST_CoveredBy(the_geom,ST_GeomFromText('POLYGON((2260000
630000, 2260000 635000,
2265000 635000, 2265000 630000, 2260000
630000))',3734)
))) INHERITS (chp02.contours);
Wecancompletewithsimilar
CREATE TABLE
queriesforourremainingtables,as
follows:
CREATE TABLE chp02.contour_N2260635
(CHECK (
ST_CoveredBy(the_geom,ST_GeomFromText('POLYGON((2260000
635000, 2260000 640000,
2265000 640000, 2265000 635000, 2260000
635000))', 3734)
))) INHERITS (chp02.contours);
CREATE TABLE chp02.contour_N2260640
(CHECK (
ST_CoveredBy(the_geom,ST_GeomFromText('POLYGON((2260000
640000, 2260000 645000,
