Mercurial > dive4elements > river
changeset 1201:4e1b475a8cba
Schema: Dropped unique constraint of x in a single line of a "Querprofil-Spur".
flys-backend/trunk@2306 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 07 Jul 2011 15:05:30 +0000 |
| parents | 7c88650ff548 |
| children | 44581b40b968 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 10 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Thu Jul 07 14:51:08 2011 +0000 +++ b/flys-backend/ChangeLog Thu Jul 07 15:05:30 2011 +0000 @@ -1,3 +1,13 @@ +2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * doc/schema/postgresql.sql: Dropped constraint that enforces the + uniquness of x in a "Querprofil-Spur". There are vertical lines + in the soundings so this constraint is violated. + + To update existing databases: + + ALTER TABLE cross_section_points DROP CONSTRAINT cross_section_points_cross_section_id_key2; + 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> * src/main/java/de/intevation/flys/importer/PRFParser.java:
--- a/flys-backend/doc/schema/postgresql.sql Thu Jul 07 14:51:08 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Thu Jul 07 15:05:30 2011 +0000 @@ -280,7 +280,6 @@ col_pos int NOT NULL, x NUMERIC NOT NULL, y NUMERIC NOT NULL - UNIQUE (cross_section_id, x), UNIQUE (cross_section_id, col_pos) );