General Bug Report: alter table tabname rename to newname does not rename extra files

Added to TODO list.

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jim Mercer
Your email address : jim@reptiles.org

Category : runtime: back-end
Severity : critical

Summary: alter table tabname rename to newname does not rename extra files

System Configuration
--------------------
Operating System : FreeBSD 2.x/3.x

PostgreSQL version : 6.4 and 6.4.2

Compiler used : gcc

Hardware:
---------
Pentium 128M ram
FreeBSD bigbird.nag.ca 3.0-RELEASE FreeBSD 3.0-RELEASE #1: Tue Feb 2 22:50:41 EST 1999 root@bigbird.nag.ca:/usr/src/sys/compile/BIGBIRD i386

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
when a table exceeds 2gb, it appears that postgres will create subfiles for the data.
when you rename a table, the sub files do no get renamed.
see backend/commands/rename.c [renamerel()]

--------------------------------------------------------------------------

Test Case:
----------
create a table in excess of 2gig, which in turn creates subfiles
in data/base/tabname.
rename the table.
the subfiles are not renamed.

--------------------------------------------------------------------------

Solution:
---------
possible solution is to check if the table has subfiles, look for those subfiles and rename them as well.

--------------------------------------------------------------------------

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026