Re: HOW TO install or use pageinspect - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: HOW TO install or use pageinspect
Date
Msg-id 1308040366.1936.13.camel@laptop
Whole thread Raw
In response to HOW TO install or use pageinspect  ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>)
Responses Re: HOW TO install or use pageinspect  ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>)
List 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


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: duplicate key violate error
Next
From: "F. BROUARD / SQLpro"
Date:
Subject: Re: HOW TO install or use pageinspect