Revision 13567
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/inputs/.TNRS/schema.sql | ||
---|---|---|
158 | 158 |
|
159 | 159 |
|
160 | 160 |
-- |
161 |
-- Name: tnrs__batch_begin(); Type: FUNCTION; Schema: TNRS; Owner: - |
|
162 |
-- |
|
163 |
|
|
164 |
CREATE FUNCTION tnrs__batch_begin() RETURNS trigger |
|
165 |
LANGUAGE plpgsql |
|
166 |
AS $$ |
|
167 |
BEGIN |
|
168 |
PERFORM util.seq__reset('pg_temp.tnrs__match_num__seq', 0); |
|
169 |
RETURN NULL; |
|
170 |
END; |
|
171 |
$$; |
|
172 |
|
|
173 |
|
|
174 |
-- |
|
161 | 175 |
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: - |
162 | 176 |
-- |
163 | 177 |
|
... | ... | |
672 | 686 |
|
673 | 687 |
|
674 | 688 |
-- |
689 |
-- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: - |
|
690 |
-- |
|
691 |
|
|
692 |
CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin(); |
|
693 |
|
|
694 |
|
|
695 |
-- |
|
675 | 696 |
-- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: - |
676 | 697 |
-- |
677 | 698 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added tnrs__batch_begin() trigger to populate the match_num (match sort order)