diff options
| author | randomdan <randomdan@localhost> | 2014-04-09 15:51:12 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2014-04-09 15:51:12 +0000 |
| commit | 5cd226583a8a95fde17bc1616350070bbe9e60d2 (patch) | |
| tree | 7314672a5a72df2993be2ffd230b8a77ead0c9ef | |
| parent | Basic support for streaming services (slow, thanks ffmpeg) and recordings (as... (diff) | |
| download | p2pvr-5cd226583a8a95fde17bc1616350070bbe9e60d2.tar.bz2 p2pvr-5cd226583a8a95fde17bc1616350070bbe9e60d2.tar.xz p2pvr-5cd226583a8a95fde17bc1616350070bbe9e60d2.zip | |
Remove fugly index definition with functional one
| -rw-r--r-- | p2pvr/datasources/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index df65cfa..fce7a4f 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -436,7 +436,7 @@ ALTER TABLE ONLY transportstreams -- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX idx_event_search ON events USING gin ((((setweight(to_tsvector('english'::regconfig, title), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(subtitle, ''::text)), 'B'::"char")) || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'C'::"char")))); +CREATE INDEX idx_event_search ON events USING gin (event_tsvector(events.*)); -- |