Problem with RENAME INDEX

Posted in 2000

Neil Truby — Mon, 20 Nov 2000 22:37:41 -0000 — source: Informix-list mailing list archive (1991-1998)

IDS 9.20 on HP-UX 11.0 I wanted to rename a table out of the way and load an empty one with the schema. These are the sort of hoops you have to jump through if your client buys Lawson! Anyway, because of the requirement for unique index names within a database, I had to rename the indexes as well. So: rename table dsinvlines to dsinvlineso; rename index idx1 to idx1a; Having done this, I couldn't rename the index back again: rename index idx1a to idx1 failed with a 319 (I think) - index not present. I couldn't drop either idx1 OR idx1a (same error). In the end I had to drop the whole dsinvlines table and re-create it. Tech SUpport haven't come up with anything as yet.