config.metabib_field_fix.sql

begin;

alter table metabib.browse_entry_def_map drop constraint browse_entry_def_map_def_fkey;
alter table metabib.author_field_entry drop constraint metabib_author_field_entry_field_pkey;
alter table config.metabib_field_index_norm_map drop constraint metabib_field_index_norm_map_field_fkey;
alter table config.metabib_field_ts_map drop constraint metabib_field_ts_map_metabib_field_fkey;
alter table metabib.identifier_field_entry drop constraint metabib_identifier_field_entry_field_pkey;
alter table metabib.keyword_field_entry drop constraint metabib_keyword_field_entry_field_pkey;
alter table config.metabib_search_alias drop constraint metabib_search_alias_field_fkey;
alter table metabib.series_field_entry drop constraint metabib_series_field_entry_field_pkey;
alter table metabib.subject_field_entry drop constraint metabib_subject_field_entry_field_pkey;
alter table metabib.title_field_entry drop constraint metabib_title_field_entry_field_pkey;
alter table search.relevance_adjustment drop constraint relevance_adjustment_field_fkey;
alter table config.z3950_index_field_map drop constraint z3950_index_field_map_metabib_field_fkey;

alter table metabib.browse_entry_def_map add constraint browse_entry_def_map_def_fkey foreign key (def) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.author_field_entry add constraint metabib_author_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table config.metabib_field_index_norm_map add constraint metabib_field_index_norm_map_field_fkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table config.metabib_field_ts_map add constraint metabib_field_ts_map_metabib_field_fkey foreign key (metabib_field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.identifier_field_entry add constraint metabib_identifier_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.keyword_field_entry add constraint metabib_keyword_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table config.metabib_search_alias add constraint metabib_search_alias_field_fkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.series_field_entry add constraint metabib_series_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.subject_field_entry add constraint metabib_subject_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table metabib.title_field_entry add constraint metabib_title_field_entry_field_pkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table search.relevance_adjustment add constraint relevance_adjustment_field_fkey foreign key (field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;
alter table config.z3950_index_field_map add constraint z3950_index_field_map_metabib_field_fkey foreign key (metabib_field) references config.metabib_field(id) on update cascade on delete cascade deferrable initially deferred;

update config.metabib_field
set id = 1001
where id = 28;

update config.metabib_field
set id = id - 1
where id > 28
and id < 1001;

SELECT setval('config.metabib_field_id_seq', GREATEST(1000, (SELECT MAX(id) + 1 FROM config.metabib_field)));

commit;