postgresql.uws.rollover.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of cadc-uws-server Show documentation
Show all versions of cadc-uws-server Show documentation
OpenCADC UWS server library
The newest version!
-- rollover Job and JobDetail tables to keep active table small and preserve history
-- rename indices
ALTER INDEX .jobdetail_fkey RENAME TO jobdetail_fkey_;
ALTER INDEX .job_creationtime RENAME TO job_creationtime_;
ALTER INDEX .job_ownerid RENAME TO job_ownerid_;
ALTER INDEX .job_pkey RENAME TO job_pkey_;
-- rename tables
alter table .Job rename to Job_;
alter table .JobDetail rename to JobDetail_;
-- the FK constraint in JobDetail->Job automatically follows the Job table rename