Revision 11906
Added by Aaron Marcuse-Kubitza almost 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 8680 | 8680 |
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 8681 | 8681 |
-- |
| 8682 | 8682 |
|
| 8683 |
CREATE UNIQUE INDEX locationevent_unique_within_parent_by_location ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), location_id, (COALESCE(stratum_id, 2147483647))) WHERE (parent_id IS NOT NULL);
|
|
| 8683 |
CREATE UNIQUE INDEX locationevent_unique_within_parent_by_location ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(location_id, 2147483647)), (COALESCE(stratum_id, 2147483647))) WHERE ((parent_id IS NOT NULL) AND (location_id IS NOT NULL));
|
|
| 8684 | 8684 |
|
| 8685 | 8685 |
|
| 8686 | 8686 |
-- |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: locationevent_unique_within_parent_by_location unique index: need COALESCE around location_id since it's nullable