Revision 118,
786 bytes
checked in by tobias.dick, 12 years ago
(diff) |
Bugfixes
|
Rev | Line | |
---|
[114] | 1 | DROP TABLE IF EXISTS map_stehendesgewaesser_g0; |
---|
| 2 | DROP SEQUENCE IF EXISTS map_stehendesgewaesser_g0_gid_seq; |
---|
| 3 | -- |
---|
| 4 | |
---|
| 5 | SELECT |
---|
| 6 | wkb_geometry, |
---|
[118] | 7 | widmung |
---|
[114] | 8 | INTO map_stehendesgewaesser_g0 |
---|
| 9 | |
---|
| 10 | FROM ( |
---|
[118] | 11 | SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry, unverschluesselt as widmung |
---|
| 12 | FROM ax_stehendesgewaesser GROUP BY widmung |
---|
[114] | 13 | ) AS wrapper; |
---|
| 14 | -- |
---|
| 15 | CREATE INDEX map_stehendesgewaesser_g0_gidx ON map_stehendesgewaesser_g0 USING GIST ( wkb_geometry ); |
---|
| 16 | CREATE SEQUENCE map_stehendesgewaesser_g0_gid_seq; |
---|
| 17 | ALTER TABLE map_stehendesgewaesser_g0 ADD COLUMN gid INTEGER; |
---|
| 18 | UPDATE map_stehendesgewaesser_g0 SET gid = nextval('map_stehendesgewaesser_g0_gid_seq'); |
---|
| 19 | ALTER TABLE map_stehendesgewaesser_g0 ALTER COLUMN gid SET DEFAULT nextval('map_stehendesgewaesser_g0_gid_seq'); |
---|
[118] | 20 | ---- |
---|
Note: See
TracBrowser
for help on using the repository browser.