From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement |
Date: | 2008-10-06 12:29:08 |
Message-ID: | 48EA0494.4020606@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane a écrit :
> Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2008-10-06 12:38:02 | Re: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement |
Previous Message | Tom Lane | 2008-10-06 12:28:26 | Re: About postgresql8.3.3 build in MS VS2005 |