| Paste number 58037: | How to delete all call numbers in Evergreen |
| Pasted by: | dbs |
| 8 months, 6 days ago | |
| #openils-evergreen | Context in IRC logs | |
| Paste contents: |
| -- Because it's fun! evergreen=# TRUNCATE asset.call_number, container.call_number_bucket_item, asset."copy", asset."copy_tranparency_map", container.copy_bucket_item, action.in_house_use, action.hold_request, action.hold_notification, action.hold_copy_map, action.transit_copy, action.hold_transit_copy, asset.copy_note, asset.call_number_note, asset.stat_cat_entry_copy_map, action.circulation; |
Annotations for this paste:
| Annotation number 1: | Don't forget the magic (thanks miker_)! |
| Pasted by: | dbs |
| 8 months, 6 days ago | |
| Context in IRC logs | |
| Paste contents: |
| -- Followed by the magical -1 call_number evergreen=# INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED'); |