1 /* contrib/pg_buffercache/pg_buffercache--1.0--1.1.sql */
3 -- complain if script is sourced in psql, rather than via ALTER EXTENSION
4 \echo Use "ALTER EXTENSION pg_buffercache UPDATE TO '1.1'" to load this file. \quit
6 -- Upgrade view to 1.1. format
7 CREATE OR REPLACE VIEW pg_buffercache AS
8 SELECT P.* FROM pg_buffercache_pages() AS P
9 (bufferid integer, relfilenode oid, reltablespace oid, reldatabase oid,
10 relforknumber int2, relblocknumber int8, isdirty bool, usagecount int2,
11 pinning_backends int4);