From: | "muteki muteki" <muteki_f(at)hotmail(dot)com> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_class and relfilenode |
Date: | 2004-02-12 06:22:58 |
Message-ID: | LAW10-F49xqDCZx4FR000049566@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>At the very least you should be running 7.2.4. We do not make
>dot-releases for entertainment value, we make them because there
>are critical bug fixes. In particular, this 7.2.4 fix:
>* Ensure pg_clog updates are sync'd to disk before marking checkpoint
>complete
>might well have something to do with your problems.
Do you know the fix to allow forcefully drop a table (even though the
relfilenode doesn't exist) is in 7.2.4?
>Views don't have underlying files at all. Shared tables live in a
>different directory. You had better study the system catalogs more
>carefully before you start writing scripts to hack them.
Thanks for the valuable information. Actually, I have tried to focus on
chapter 3 of PostgreSQL 7.2 Documentation and having difficulty in finding
the information you mentioned above. Am I reading the right document?
Thanks,
--muteki
_________________________________________________________________
Optimize your Internet experience to the max with the new MSN Premium
Internet Software. http://click.atdmt.com/AVE/go/onm00200359ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2004-02-12 06:30:54 | Re: pg_class and relfilenode |
Previous Message | muteki muteki | 2004-02-12 06:08:30 | Re: pg_class and relfilenode |