We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parente45ae40 commit9e84cccCopy full SHA for 9e84ccc
doc/src/sgml/lo.sgml
@@ -76,7 +76,15 @@ CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image
76
<para>
77
For each column that will contain unique references to large objects,
78
create a <literal>BEFORE UPDATE OR DELETE</> trigger, and give the column
79
- name as the sole trigger argument. If you need multiple <type>lo</>
+ name as the sole trigger argument. You can also restrict the trigger
80
+ to only execute on updates to the column with:
81
+
82
+<programlisting>
83
+CREATE TRIGGER t_raster BEFORE UPDATE OF raster OR DELETE ON image
84
+ FOR EACH ROW EXECUTE PROCEDURE lo_manage(raster);
85
+</programlisting>
86
87
+ If you need multiple <type>lo</>
88
columns in the same table, create a separate trigger for each one,
89
remembering to give a different name to each trigger on the same table.
90
</para>