Skip to content
Snippets Groups Projects

bug: duplicate index name

Merged bug: duplicate index name
development into master
Merged Christoffer Stoll requested to merge development into master
Compare
and
1 file
+ 1
− 1
Compare changes
  • Side-by-side
  • Inline
sql/pre_aggregates.sql
+ 1
− 1
------------------------------------------------------------------------------------
create index idx_obs_spoid_day on public.observations (sampling_point_id, date_trunc('year'::text, from_time));
create index idx_obs_spoid_year on public.observations (sampling_point_id, date_trunc('year'::text, from_time));
create index idx_obs_spoid_day on public.observations (sampling_point_id, date_trunc('day'::text, from_time));
VACUUM FULL ANALYZE observations;