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 ************************* -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
