|
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 |
|
|