This file is indexed.

/usr/share/postgresql/9.1/extension/pre_prepare.sql is in postgresql-9.1-preprepare 0.5-1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
---
--- pre_prepare exports only a prepare_all() function.
---
CREATE OR REPLACE FUNCTION prepare_all()
RETURNS void
AS '$libdir/pre_prepare', 'prepare_all'
LANGUAGE 'C' STRICT VOLATILE;

CREATE OR REPLACE FUNCTION prepare_all(text)
RETURNS void
AS '$libdir/pre_prepare', 'prepare_all'
LANGUAGE 'C' STRICT VOLATILE;

CREATE OR REPLACE FUNCTION discard()
RETURNS void
LANGUAGE SQL
AS $$
  SET SESSION AUTHORIZATION DEFAULT;
  RESET ALL;
  CLOSE ALL;
  UNLISTEN *;
  SELECT pg_advisory_unlock_all();
  DISCARD PLANS;
  DISCARD TEMP;
$$;