HOW TO install or use pageinspect

From: "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr>
To: PGSQL - Genearal <pgsql-general(at)postgresql(dot)org>
Subject: HOW TO install or use pageinspect
Date: 2011-06-14 08:06:57
Message-ID: 4DF716A1.5090302@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 *************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-06-14 08:30:03 Proposition fetch cursors
Previous Message Craig Ringer 2011-06-14 08:01:09 Re: how to install plpython?