Tom Lane a écrit : > Heikki Linnakangas <[EMAIL PROTECTED]> writes: >> The trivial fix is to just force a checkpoint in ALTER TABLE SET >> TABLESPACE. Can we do better than that? Perhaps only force a checkpoint >> when we find that the file already exists. > > If ALTER TABLE SET TABLESPACE is assuming that it can always use the > same relfilenode number in the new space as in the old, it's just plain > broken. We need to fix that assumption. >
Do you mean the backend should change the relfilenode number whenever we use the ALTER TABLE SET TABLESPACE ? I can't think of a way to get twice the same relfilenode. Perhaps a better question would be : how the next relfilenode is computed? -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers