/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | failure_create_distributed_table_non_empty.sql | 29 SELECT citus.mitmproxy('conn.cancel(' || pg_backend_pid() || ')'); 43 SELECT citus.mitmproxy('conn.onQuery(query="^CREATE SCHEMA").cancel(' || pg_backend_pid() || ')'); 91 SELECT citus.mitmproxy('conn.onQuery(query="COPY").cancel(' || pg_backend_pid() || ')'); 96 SELECT citus.mitmproxy('conn.onCommandComplete(command="COPY").cancel(' || pg_backend_pid() || ')'… 153 SELECT citus.mitmproxy('conn.onQuery(query="^ROLLBACK").cancel(' || pg_backend_pid() || ')'); 183 SELECT citus.mitmproxy('conn.onQuery(query="^COPY").cancel(' || pg_backend_pid() || ')'); 227 SELECT citus.mitmproxy('conn.cancel(' || pg_backend_pid() || ')'); 275 SELECT citus.mitmproxy('conn.onQuery(query="COPY").cancel(' || pg_backend_pid() || ')'); 294 SELECT citus.mitmproxy('conn.onQuery(query="^ROLLBACK").cancel(' || pg_backend_pid() || ')'); 314 SELECT citus.mitmproxy('conn.onQuery(query="^COMMIT").cancel(' || pg_backend_pid() || ')'); [all …]
|
H A D | multi_distributed_transaction_id.sql | 21 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 27 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 35 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 42 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 51 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 59 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 63 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 70 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 75 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu…
|
H A D | failure_truncate.sql | 46 SELECT citus.mitmproxy('conn.onAuthenticationOk().cancel(' || pg_backend_pid() || ')'); 74 ….onQuery(query="TRUNCATE TABLE truncate_failure.test_table").cancel(' || pg_backend_pid() || ')'); 98 SELECT citus.mitmproxy('conn.onQuery(query="^COMMIT").cancel(' || pg_backend_pid() || ')'); 125 SELECT citus.mitmproxy('conn.onCommandComplete(command="^COMMIT").cancel(' || pg_backend_pid() || … 150 SELECT citus.mitmproxy('conn.onQuery(query="PREPARE TRANSACTION").cancel(' || pg_backend_pid() || … 168 SELECT citus.mitmproxy('conn.onQuery(query="^TRUNCATE TABLE").after(2).cancel(' || pg_backend_pid(… 188 …proxy('conn.onCommandComplete(command="PREPARE TRANSACTION").cancel(' || pg_backend_pid() || ')'); 208 SELECT citus.mitmproxy('conn.onAuthenticationOk().cancel(' || pg_backend_pid() || ')'); 236 …onQuery(query="^TRUNCATE TABLE truncate_failure.test_table").cancel(' || pg_backend_pid() || ')'); 254 …roxy('conn.onCommandComplete(command="^PREPARE TRANSACTION").cancel(' || pg_backend_pid() || ')'); [all …]
|
H A D | failure_ddl.sql | 39 SELECT citus.mitmproxy('conn.onAuthenticationOk().cancel(' || pg_backend_pid() || ')'); 61 …mproxy('conn.onQuery(query="worker_apply_shard_ddl_command").cancel(' || pg_backend_pid() || ')'); 79 SELECT citus.mitmproxy('conn.onQuery(query="^COMMIT").cancel(' || pg_backend_pid() || ')'); 108 SELECT citus.mitmproxy('conn.onCommandComplete(command="^COMMIT").cancel(' || pg_backend_pid() || … 129 SELECT citus.mitmproxy('conn.onQuery(query="ROLLBACK").cancel(' || pg_backend_pid() || ')'); 157 SELECT citus.mitmproxy('conn.onAuthenticationOk().cancel(' || pg_backend_pid() || ')'); 177 …mproxy('conn.onQuery(query="worker_apply_shard_ddl_command").cancel(' || pg_backend_pid() || ')'); 196 …proxy('conn.onCommandComplete(command="PREPARE TRANSACTION").cancel(' || pg_backend_pid() || ')'); 281 SELECT citus.mitmproxy('conn.onAuthenticationOk().cancel(' || pg_backend_pid() || ')'); 301 …mproxy('conn.onQuery(query="worker_apply_shard_ddl_command").cancel(' || pg_backend_pid() || ')'); [all …]
|
H A D | failure_vacuum.sql | 38 SELECT citus.mitmproxy('conn.onQuery(query="^VACUUM").cancel(' || pg_backend_pid() || ')'); 41 SELECT citus.mitmproxy('conn.onQuery(query="^ANALYZE").cancel(' || pg_backend_pid() || ')'); 45 SELECT citus.mitmproxy('conn.onQuery(query="^COMMIT").cancel(' || pg_backend_pid() || ')'); 57 SELECT citus.mitmproxy('conn.onQuery(query="^VACUUM.*other").cancel(' || pg_backend_pid() || ')');
|
H A D | failure_create_reference_table.sql | 34 SELECT citus.mitmproxy('conn.onCommandComplete(command="BEGIN").cancel(' || pg_backend_pid() || ')'… 46 SELECT citus.mitmproxy('conn.onCommandComplete(command="SELECT 1").cancel(' || pg_backend_pid() || … 58 SELECT citus.mitmproxy('conn.onCommandComplete(command="COPY 3").cancel(' || pg_backend_pid() || ')… 104 SELECT citus.mitmproxy('conn.onQuery(query="^ROLLBACK").cancel(' || pg_backend_pid() || ')');
|
H A D | failure_single_select.sql | 39 SELECT citus.mitmproxy('conn.onQuery(query="^SELECT").cancel(' || pg_backend_pid() || ')'); 44 SELECT citus.mitmproxy('conn.onQuery(query="^SELECT").cancel(' || pg_backend_pid() || ')'); 60 SELECT citus.mitmproxy('conn.onQuery(query="^SELECT").after(1).cancel(' || pg_backend_pid() || ')'… 100 SELECT citus.mitmproxy('conn.onQuery(query="^SELECT").after(1).cancel(' || pg_backend_pid() || ')'…
|
H A D | failure_multi_dml.sql | 38 SELECT citus.mitmproxy('conn.onQuery(query="^DELETE").cancel(' || pg_backend_pid() || ')'); 66 SELECT citus.mitmproxy('conn.onQuery(query="^INSERT").cancel(' || pg_backend_pid() || ')'); 94 SELECT citus.mitmproxy('conn.onQuery(query="^UPDATE").cancel(' || pg_backend_pid() || ')'); 137 SELECT citus.mitmproxy('conn.onQuery(query="^PREPARE TRANSACTION").cancel(' || pg_backend_pid() ||… 181 SELECT citus.mitmproxy('conn.onQuery(query="^COMMIT").cancel(' || pg_backend_pid() || ')'); 261 SELECT citus.mitmproxy('conn.onQuery(query="^PREPARE").cancel(' || pg_backend_pid() || ')');
|
H A D | failure_create_table.sql | 69 …ry(query="^BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED").cancel(' || pg_backend_pid() || ')'); 90 SELECT citus.mitmproxy('conn.onQuery(query="CREATE TABLE").cancel(' || pg_backend_pid() || ')'); 105 …proxy('conn.onCommandComplete(command="PREPARE TRANSACTION").cancel(' || pg_backend_pid() || ')'); 151 …ry(query="^BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED").cancel(' || pg_backend_pid() || ')'); 211 …ry(query="^BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED").cancel(' || pg_backend_pid() || ')'); 268 …proxy('conn.onCommandComplete(command="PREPARE TRANSACTION").cancel(' || pg_backend_pid() || ')');
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | multi_distributed_transaction_id.out | 21 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 35 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 46 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 55 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 72 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 86 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 93 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 107 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu… 115 …ode_identifier, transaction_number, transaction_stamp, (process_id = pg_backend_pid()) FROM get_cu…
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/isolation/expected/ |
H A D | detach-partition-concurrently-4.out | 4 step s2snitch: insert into d4_pid select pg_backend_pid(); 28 step s2snitch: insert into d4_pid select pg_backend_pid(); 44 step s2snitch: insert into d4_pid select pg_backend_pid(); 68 step s2snitch: insert into d4_pid select pg_backend_pid(); 84 step s2snitch: insert into d4_pid select pg_backend_pid(); 109 step s2snitch: insert into d4_pid select pg_backend_pid(); 126 step s2snitch: insert into d4_pid select pg_backend_pid(); 153 step s2snitch: insert into d4_pid select pg_backend_pid(); 172 step s2snitch: insert into d4_pid select pg_backend_pid(); 193 step s2snitch: insert into d4_pid select pg_backend_pid(); [all …]
|
H A D | detach-partition-concurrently-3.out | 4 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 36 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 59 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 88 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 110 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 142 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 179 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 207 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 235 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); 259 step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); [all …]
|
/dports/databases/py-postgresql/py-postgresql-1.1.0/postgresql/lib/ |
H A D | libsys.sql | 168 FROM pg_catalog.pg_stat_activity WHERE procpid = pg_catalog.pg_backend_pid() 183 FROM pg_catalog.pg_stat_activity WHERE pid = pg_catalog.pg_backend_pid() 199 FROM pg_catalog.pg_stat_activity WHERE procpid = pg_catalog.pg_backend_pid(); 216 procpid != pg_catalog.pg_backend_pid() 225 pid != pg_catalog.pg_backend_pid() 234 procpid != pg_catalog.pg_backend_pid() 243 pid != pg_catalog.pg_backend_pid() 266 WHERE listenerpid = pg_catalog.pg_backend_pid();
|