Tom Lane wrote: > In the above example, the contrib code would have not done the right > thing at all --- if I'm not mistaken, it would have kept handing back > the size of the original, pre-TRUNCATE file, since the new pg_class > row with the new relfilenode isn't committed yet. So it wouldn't have > done what you wish anyway.
It wouldn't have worked anyway because it used the Oid to search the file, not the relfilenode. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
