Re: Bug in VACUUM FULL ?

Tom Lane wrote:
 >
 > Please check if this makes it go away for you --- I'm a bit busy
 > at the moment.
 >

Thanks a lot, Tom. It seems to work fine for me. I will do some
more tests and report if I see any issue. Btw, the patch as per
your suggestion is attached.

Thanks,
Pavan

*** src/backend/commands/vacuum.c    2007-02-16 04:53:22.000000000 +0530
--- src/backend/commands/vacuum.c    2007-03-08 09:25:15.016991272 +0530
***************
*** 718,724 ****
--- 718,732 ----
       * If anything changed, write out the tuple
       */
      if (dirty)
+     {
          heap_inplace_update(rd, ctup);
+         /* the above sends a cache inval message */
+     }
+     else
+     {
+         /* no need to change tuple, but force relcache inval anyway */
+         CacheInvalidateRelcacheByTuple(ctup);
+     }

      heap_close(rd, RowExclusiveLock);
  }