Home
last modified time | relevance | path

Searched refs:pg_trigger (Results 1 – 25 of 745) sorted by relevance

12345678910>>...30

/dports/databases/slony1v2/slony1-2.2.10/src/backend/
H A Dslony1_funcs.v84.sql116 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 Dpg_trigger.h36 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dpg_trigger.h34 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 Dcitus_local_tables_mx.sql48 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 Dcitus_local_table_triggers.sql131 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 DDbStructure.hs330 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 Doidjoins.out172 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 Doidjoins.out172 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 Doidjoins.out172 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 Doidjoins.out172 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 Doidjoins.out172 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 Doidjoins.out172 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 Doidjoins.out172 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 Dtriggers.sql352 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 Dtriggers.sql352 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 Dtriggers.sql352 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 Dtriggers.sql352 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 Dtriggers.sql352 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 Dtriggers.sql352 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 …]

12345678910>>...30