Re: HOW TO install or use pageinspect

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr>
Cc: PGSQL - Genearal <pgsql-general(at)postgresql(dot)org>
Subject: Re: HOW TO install or use pageinspect
Date: 2011-06-14 08:32:46
Message-ID: 1308040366.1936.13.camel@laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Tue, 2011-06-14 at 10:06 +0200, F. BROUARD / SQLpro wrote:
> [...]
> I have a 9.1 PG Server on Windows XP
> The pageinspect.dll is in C:\Program Files\PostgreSQL\9.1\lib
> I am postgresql user in the database (names DB_TEST).
> But I cannot use the functions like
> SELECT * FROM heap_page_items(get_raw_page('aTable', 0))
> They does not appear in the postgreSQL catalog in the function list...
> What am I missing ?
>

Did you install the extension first? with "CREATE EXTENSION
pageinstall;" as you are on 9.1.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message F. BROUARD / SQLpro 2011-06-14 08:39:41 Re: HOW TO install or use pageinspect
Previous Message AI Rumman 2011-06-14 08:30:18 duplicate key violate error