partition-trigger-doc-v1.patch
text/plain
Filename: partition-trigger-doc-v1.patch
Type: text/plain
Part: 0
Message:
Partitioning triggers doc patch
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: context
Series: patch v1
| File | + | − |
|---|---|---|
| doc/src/sgml/ddl.sgml | 4 | 0 |
*** a/doc/src/sgml/ddl.sgml
--- b/doc/src/sgml/ddl.sgml
***************
*** 2411,2416 **** VALUES ('New York', NULL, NULL, 'NY');
--- 2411,2420 ----
constraints on this table, unless you intend them to
be applied equally to all partitions. There is no point
in defining any indexes or unique constraints on it, either.
+ Because triggers on this table will not be fired for operations
+ on the related partitions, there is usually no reason to create
+ triggers on it other than the optional trigger described below
+ to redirect operations to the appropriate partitions.
</para>
</listitem>