Re: [GENERAL] how do I clear a page, or set an item in a page to

2005-03-21 Thread Eric Parusel
Tom Lane wrote: Eric Parusel <[EMAIL PROTECTED]> writes: ok, I can dd, if=/dev/zero of=base/dbnum/tablenum, but how do I figure how where and how much to write over? Is there an easy to see or calculate offset value for a particular page number? (28393) dd bs=8k seek=28393 count=1 sh

Re: [GENERAL] how do I clear a page, or set an item in a page to

2005-03-21 Thread Eric Parusel
Tom Lane wrote: Eric Parusel <[EMAIL PROTECTED]> writes: I've got a mucked up page in my db, and I can't complete a database dump until a particular page is fixed/removed from the table. :( Zeroing the page is the most painless way. dd from /dev/zero will get it done --- but no

[GENERAL] how do I clear a page, or set an item in a page to 'free'?

2005-03-21 Thread Eric Parusel
I've got a mucked up page in my db, and I can't complete a database dump until a particular page is fixed/removed from the table. :( Could someone let me know the proper way to go about making a change such as this?: 1) Clear the page or 2) Set the bad items in the page to 'free' I can see the

[GENERAL] pgsql function using C++?, or at least C interfacing with C++ lib?

2004-10-16 Thread Eric Parusel
Hello, I've got a C++ library I need to use, and I want to use it from a pgsql function. Would anyone happen to have any examples of how to accomplish something like this? I see examples of C-based functions for pgsql (like dbsize, etc, in contrib). Which way should I go about this? 1) C based