|
21 | 21 | void |
22 | 22 | install_db_support_functions(constchar*db_name) |
23 | 23 | { |
24 | | -PGconn*conn=connectToServer(&new_cluster,db_name); |
25 | | -
|
26 | | -/* suppress NOTICE of dropped objects */ |
27 | | -PQclear(executeQueryOrDie(conn, |
28 | | -"SET client_min_messages = warning;")); |
29 | | -PQclear(executeQueryOrDie(conn, |
30 | | -"DROP SCHEMA IF EXISTS binary_upgrade CASCADE;")); |
31 | | -PQclear(executeQueryOrDie(conn, |
32 | | -"RESET client_min_messages;")); |
33 | | - |
34 | | -PQclear(executeQueryOrDie(conn, |
35 | | -"CREATE SCHEMA binary_upgrade;")); |
36 | | - |
37 | | -PQclear(executeQueryOrDie(conn, |
38 | | -"CREATE OR REPLACE FUNCTION " |
39 | | -"binary_upgrade.set_next_pg_type_oid(OID) " |
40 | | -"RETURNS VOID " |
41 | | -"AS '$libdir/pg_upgrade_support' " |
42 | | -"LANGUAGE C STRICT;")); |
43 | | -PQclear(executeQueryOrDie(conn, |
44 | | -"CREATE OR REPLACE FUNCTION " |
45 | | -"binary_upgrade.set_next_array_pg_type_oid(OID) " |
46 | | -"RETURNS VOID " |
47 | | -"AS '$libdir/pg_upgrade_support' " |
48 | | -"LANGUAGE C STRICT;")); |
49 | | -PQclear(executeQueryOrDie(conn, |
50 | | -"CREATE OR REPLACE FUNCTION " |
51 | | -"binary_upgrade.set_next_toast_pg_type_oid(OID) " |
52 | | -"RETURNS VOID " |
53 | | -"AS '$libdir/pg_upgrade_support' " |
54 | | -"LANGUAGE C STRICT;")); |
55 | | -PQclear(executeQueryOrDie(conn, |
56 | | -"CREATE OR REPLACE FUNCTION " |
57 | | -"binary_upgrade.set_next_heap_pg_class_oid(OID) " |
58 | | -"RETURNS VOID " |
59 | | -"AS '$libdir/pg_upgrade_support' " |
60 | | -"LANGUAGE C STRICT;")); |
61 | | -PQclear(executeQueryOrDie(conn, |
62 | | -"CREATE OR REPLACE FUNCTION " |
63 | | -"binary_upgrade.set_next_index_pg_class_oid(OID) " |
64 | | -"RETURNS VOID " |
65 | | -"AS '$libdir/pg_upgrade_support' " |
66 | | -"LANGUAGE C STRICT;")); |
67 | | -PQclear(executeQueryOrDie(conn, |
68 | | -"CREATE OR REPLACE FUNCTION " |
69 | | -"binary_upgrade.set_next_toast_pg_class_oid(OID) " |
70 | | -"RETURNS VOID " |
71 | | -"AS '$libdir/pg_upgrade_support' " |
72 | | -"LANGUAGE C STRICT;")); |
73 | | -PQclear(executeQueryOrDie(conn, |
74 | | -"CREATE OR REPLACE FUNCTION " |
75 | | -"binary_upgrade.set_next_pg_enum_oid(OID) " |
76 | | -"RETURNS VOID " |
77 | | -"AS '$libdir/pg_upgrade_support' " |
78 | | -"LANGUAGE C STRICT;")); |
79 | | -PQclear(executeQueryOrDie(conn, |
80 | | -"CREATE OR REPLACE FUNCTION " |
81 | | -"binary_upgrade.set_next_pg_authid_oid(OID) " |
82 | | -"RETURNS VOID " |
83 | | -"AS '$libdir/pg_upgrade_support' " |
84 | | -"LANGUAGE C STRICT;")); |
85 | | -PQfinish(conn); |
| 24 | +PGconn*conn=connectToServer(&new_cluster,db_name); |
| 25 | + |
| 26 | +/* suppress NOTICE of dropped objects */ |
| 27 | +PQclear(executeQueryOrDie(conn, |
| 28 | +"SET client_min_messages = warning;")); |
| 29 | +PQclear(executeQueryOrDie(conn, |
| 30 | +"DROP SCHEMA IF EXISTS binary_upgrade CASCADE;")); |
| 31 | +PQclear(executeQueryOrDie(conn, |
| 32 | +"RESET client_min_messages;")); |
| 33 | + |
| 34 | +PQclear(executeQueryOrDie(conn, |
| 35 | +"CREATE SCHEMA binary_upgrade;")); |
| 36 | + |
| 37 | +PQclear(executeQueryOrDie(conn, |
| 38 | +"CREATE OR REPLACE FUNCTION " |
| 39 | +"binary_upgrade.set_next_pg_type_oid(OID) " |
| 40 | +"RETURNS VOID " |
| 41 | +"AS '$libdir/pg_upgrade_support' " |
| 42 | +"LANGUAGE C STRICT;")); |
| 43 | +PQclear(executeQueryOrDie(conn, |
| 44 | +"CREATE OR REPLACE FUNCTION " |
| 45 | +"binary_upgrade.set_next_array_pg_type_oid(OID) " |
| 46 | +"RETURNS VOID " |
| 47 | +"AS '$libdir/pg_upgrade_support' " |
| 48 | +"LANGUAGE C STRICT;")); |
| 49 | +PQclear(executeQueryOrDie(conn, |
| 50 | +"CREATE OR REPLACE FUNCTION " |
| 51 | +"binary_upgrade.set_next_toast_pg_type_oid(OID) " |
| 52 | +"RETURNS VOID " |
| 53 | +"AS '$libdir/pg_upgrade_support' " |
| 54 | +"LANGUAGE C STRICT;")); |
| 55 | +PQclear(executeQueryOrDie(conn, |
| 56 | +"CREATE OR REPLACE FUNCTION " |
| 57 | +"binary_upgrade.set_next_heap_pg_class_oid(OID) " |
| 58 | +"RETURNS VOID " |
| 59 | +"AS '$libdir/pg_upgrade_support' " |
| 60 | +"LANGUAGE C STRICT;")); |
| 61 | +PQclear(executeQueryOrDie(conn, |
| 62 | +"CREATE OR REPLACE FUNCTION " |
| 63 | +"binary_upgrade.set_next_index_pg_class_oid(OID) " |
| 64 | +"RETURNS VOID " |
| 65 | +"AS '$libdir/pg_upgrade_support' " |
| 66 | +"LANGUAGE C STRICT;")); |
| 67 | +PQclear(executeQueryOrDie(conn, |
| 68 | +"CREATE OR REPLACE FUNCTION " |
| 69 | +"binary_upgrade.set_next_toast_pg_class_oid(OID) " |
| 70 | +"RETURNS VOID " |
| 71 | +"AS '$libdir/pg_upgrade_support' " |
| 72 | +"LANGUAGE C STRICT;")); |
| 73 | +PQclear(executeQueryOrDie(conn, |
| 74 | +"CREATE OR REPLACE FUNCTION " |
| 75 | +"binary_upgrade.set_next_pg_enum_oid(OID) " |
| 76 | +"RETURNS VOID " |
| 77 | +"AS '$libdir/pg_upgrade_support' " |
| 78 | +"LANGUAGE C STRICT;")); |
| 79 | +PQclear(executeQueryOrDie(conn, |
| 80 | +"CREATE OR REPLACE FUNCTION " |
| 81 | +"binary_upgrade.set_next_pg_authid_oid(OID) " |
| 82 | +"RETURNS VOID " |
| 83 | +"AS '$libdir/pg_upgrade_support' " |
| 84 | +"LANGUAGE C STRICT;")); |
| 85 | +PQfinish(conn); |
86 | 86 | } |
87 | 87 |
|
88 | 88 |
|
|