postgresql.uws.upgrade-1.2.18.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!
-- rename indices to make rollover maintenance cleaner
ALTER INDEX .jobid_fkey RENAME TO jobdetail_fkey;
ALTER INDEX ._jobIndex_creationTime RENAME TO job_creationTime;
ALTER INDEX ._jobIndex_ownerID RENAME TO job_ownerID;