Re: [BUGS] Bug #529: UPDATE fails after an index is changed

2001-12-03 Thread Tom Lane
[EMAIL PROTECTED] writes: > I had to drop and re-create an index on a table for a large insert. Then I needed to >run an UPDATE on a different table that gets its values from the first table. UPDATE >fails with this error message: > 'ERROR: Index 6708054 does not exist'. What do you mean by "

[BUGS] Bug #529: UPDATE fails after an index is changed

2001-12-03 Thread pgsql-bugs
Paul Smith ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description UPDATE fails after an index is changed Long Description I had to drop and re-create an index on a table for a large insert. Then I needed to run an UPDATE on a differe