X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=add_constraints.sql;h=9b7eb7669d300f9f16865c0445b906b38683c14f;hb=f544f13b91fa2ebc2a5c91eb81098d93af639bfe;hp=65625eb6747e54b3c079ad1e86732beb2ac4f2ab;hpb=f99c517b170e129503e9be84c18f36e9497842ef;p=dak.git diff --git a/add_constraints.sql b/add_constraints.sql index 65625eb6..9b7eb766 100644 --- a/add_constraints.sql +++ b/add_constraints.sql @@ -63,6 +63,9 @@ CREATE FUNCTION priority_id_max() RETURNS INT4 CREATE FUNCTION override_type_id_max() RETURNS INT4 AS 'SELECT max(id) FROM override_type' LANGUAGE 'sql'; +CREATE FUNCTION maintainer_id_max() RETURNS INT4 + AS 'SELECT max(id) FROM maintainer' + LANGUAGE 'sql'; SELECT setval('files_id_seq', files_id_max()); SELECT setval('source_id_seq', source_id_max()); @@ -73,6 +76,7 @@ SELECT setval('bin_associations_id_seq', bin_associations_id_max()); SELECT setval('section_id_seq', section_id_max()); SELECT setval('priority_id_seq', priority_id_max()); SELECT setval('override_type_id_seq', override_type_id_max()); +SELECT setval('maintainer_id_seq', maintainer_id_max()); -- Vacuum the tables for efficency