On Fri, Jun 20, 2008 at 3:20 PM, Bill Ott <[EMAIL PROTECTED]> wrote: > >>> I believe you noted to me previously that this requires an initdb after >>> the >>> recompile? >>> >>> >> >> Indeed. The on-disk format will be different >> >> Attached is a patch for Postgres 8.2.9, but it should apply to any >> version without any trouble. >> >> > > Thanks again Mike > > ...but on a Friday afternoon, > > delete from metabib.full_rec where length(value) > 2700; >
That'll get it done! :) Of course, if you edit and then save the same records, they'll fail due to index constraints. I'm now toying with the idea of hiding that table behind a view that would allow a substring() index to be used on arbitrary queries ... I'll let the list know how the testing of that goes. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [EMAIL PROTECTED] | web: http://www.esilibrary.com
