/dports/databases/slony1v2/slony1-2.2.10/src/backend/ |
H A D | slony1_funcs.v84.sql | 116 where 2 <> (select count(*) from pg_catalog.pg_trigger, 118 pg_trigger.tgrelid=pg_class.oid 136 and exists (select 1 from pg_catalog.pg_trigger 137 … where pg_trigger.tgname like '_@CLUSTERNAME@_truncatetrigger' and pg_trigger.tgenabled = 'O' 138 and pg_trigger.tgrelid=tab_reloid ) 139 and exists (select 1 from pg_catalog.pg_trigger 140 … where pg_trigger.tgname like '_@CLUSTERNAME@_truncatedeny' and pg_trigger.tgenabled = 'D' 148 and exists (select 1 from pg_catalog.pg_trigger 149 … where pg_trigger.tgname like '_@CLUSTERNAME@_truncatetrigger' and pg_trigger.tgenabled = 'D' 151 and exists (select 1 from pg_catalog.pg_trigger [all …]
|
/dports/databases/pgpool-II-43/pgpool-II-4.3.0/src/include/parser/ |
H A D | pg_trigger.h | 36 CATALOG(pg_trigger,2620,TriggerRelationId) 41 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 84 DECLARE_TOAST(pg_trigger, 2336, 2337); 86 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 88 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 90 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-server/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/postgresql14-client/postgresql-14.1/src/include/catalog/ |
H A D | pg_trigger.h | 34 CATALOG(pg_trigger,2620,TriggerRelationId) 39 Oid tgparentid BKI_LOOKUP_OPT(pg_trigger); /* OID of parent 82 DECLARE_TOAST(pg_trigger, 2336, 2337); 84 DECLARE_INDEX(pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops)); 86 DECLARE_UNIQUE_INDEX(pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_o… 88 DECLARE_UNIQUE_INDEX_PKEY(pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops));
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | citus_local_tables_mx.sql | 48 SELECT COUNT(*) FROM pg_depend, pg_trigger, pg_extension 49 WHERE pg_trigger.tgrelid='citus_local_tables_mx.citus_local_table'::regclass AND 50 pg_trigger.tgname='renamed_trigger' AND 51 pg_trigger.tgenabled='D' AND 54 pg_trigger.oid=pg_depend.objid AND
|
H A D | citus_local_table_triggers.sql | 131 FROM pg_trigger 169 SELECT tgname FROM pg_depend, pg_trigger, pg_extension 171 pg_trigger.oid=pg_depend.objid and extname='seg'
|
/dports/www/hs-postgrest/postgrest-8.0.0/src/PostgREST/ |
H A D | DbStructure.hs | 330 FROM pg_trigger 332 pg_trigger.tgrelid = c.oid function 342 FROM pg_trigger 344 pg_trigger.tgrelid = c.oid function 354 FROM pg_trigger 356 pg_trigger.tgrelid = c.oid function 480 FROM pg_trigger 482 pg_trigger.tgrelid = c.oid function 498 FROM pg_trigger 500 pg_trigger.tgrelid = c.oid function [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/expected/ |
H A D | oidjoins.out | 172 NOTICE: checking pg_trigger {tgrelid} => pg_class {oid} 173 NOTICE: checking pg_trigger {tgparentid} => pg_trigger {oid} 174 NOTICE: checking pg_trigger {tgfoid} => pg_proc {oid} 175 NOTICE: checking pg_trigger {tgconstrrelid} => pg_class {oid} 176 NOTICE: checking pg_trigger {tgconstrindid} => pg_class {oid} 177 NOTICE: checking pg_trigger {tgconstraint} => pg_constraint {oid} 178 NOTICE: checking pg_trigger {tgrelid,tgattr} => pg_attribute {attrelid,attnum}
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1400 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1406 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1409 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1689 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1722 select tgrelid::regclass, count(*) from pg_trigger 1740 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1744 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1753 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1757 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1398 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1404 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1407 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1766 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1799 select tgrelid::regclass, count(*) from pg_trigger 1817 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1821 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1830 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1834 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1398 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1404 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1407 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1766 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1799 select tgrelid::regclass, count(*) from pg_trigger 1817 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1821 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1830 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1834 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1398 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1404 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1407 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1766 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1799 select tgrelid::regclass, count(*) from pg_trigger 1817 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1821 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1830 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1834 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1398 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1404 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1407 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1766 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1799 select tgrelid::regclass, count(*) from pg_trigger 1817 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1821 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1830 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1834 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | triggers.sql | 352 SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a'; 1398 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1404 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1407 select tgrelid::regclass, tgname, tgfoid::regproc from pg_trigger 1766 from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid) 1799 select tgrelid::regclass, count(*) from pg_trigger 1817 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1821 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1830 select tgrelid::regclass, tgname, tgenabled from pg_trigger 1834 select tgrelid::regclass, tgname, tgenabled from pg_trigger [all …]
|