Re: [GENERAL] HOW TO install or use pageinspect

2011-06-14 Thread F. BROUARD / SQLpro
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

Re: [GENERAL] HOW TO install or use pageinspect

2011-06-14 Thread Guillaume Lelarge
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_i

[GENERAL] HOW TO install or use pageinspect

2011-06-14 Thread F. BROUARD / SQLpro
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 ca