Thread: HOW TO install or use pageinspect

HOW TO install or use pageinspect

From
"F. BROUARD / SQLpro"
Date:
Hi there,

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 ?

Thanks

--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR  :  http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************


Re: HOW TO install or use pageinspect

From
Guillaume Lelarge
Date:
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


Re: HOW TO install or use pageinspect

From
"F. BROUARD / SQLpro"
Date:
Hi Gleu,

OK I run :

CREATE EXTENSION pageinspect

And it works.

Thanks

Le 14/06/2011 10:32, Guillaume Lelarge a écrit :
>
> 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.
>
>


--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR  :  http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************