jxie@leeonsoft.com (12) [Avatar] Offline
On page 58, the following sql produces a syntax error at or near "gid":

CREATE TABLE roads_ma_me_nh(CONSTRAINT roads_ma_me_pk PRIMARY KEY gid) INHERITS (roads) WITH (OIDS=FALSE);

regina.leo (265) [Avatar] Offline
Re: syntax error at or near "gid"

Thanks for the catch should be in our next batch of updates.

The below should have read

CREATE TABLE roads_ma_me_nh(
CONSTRAINT roads_ma_me_pk PRIMARY KEY (gid)
INHERITS (roads);

We also too ut the OIDS=FALSE since that's the default in versions of PostgreSQL after around 7.4.