diff options
author | Bruce Momjian <bruce@momjian.us> | 2012-08-14 23:25:20 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2012-08-14 23:25:20 -0400 |
commit | 864de654c8271ab7f9fb8397fcc665ffed93645c (patch) | |
tree | 8999b5ab1ab855ca01f44d24921139a0f55e9469 | |
parent | 9e84cccff28e52ab76aa3d3e88bd815dc36d24d8 (diff) | |
download | postgresql-864de654c8271ab7f9fb8397fcc665ffed93645c.tar.gz postgresql-864de654c8271ab7f9fb8397fcc665ffed93645c.zip |
Add more limited large object trigger example.
-rw-r--r-- | doc/src/sgml/lo.sgml | 9 |
1 files changed, 2 insertions, 7 deletions
diff --git a/doc/src/sgml/lo.sgml b/doc/src/sgml/lo.sgml index 0c11fdc20aa..cd4ed6030b7 100644 --- a/doc/src/sgml/lo.sgml +++ b/doc/src/sgml/lo.sgml @@ -77,13 +77,8 @@ CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image For each column that will contain unique references to large objects, create a <literal>BEFORE UPDATE OR DELETE</> trigger, and give the column name as the sole trigger argument. You can also restrict the trigger - to only execute on updates to the column with: - -<programlisting> -CREATE TRIGGER t_raster BEFORE UPDATE OF raster OR DELETE ON image - FOR EACH ROW EXECUTE PROCEDURE lo_manage(raster); -</programlisting> - + to only execute on updates to the column by using <literal>BEFORE UPDATE + OF</literal> <replaceable class="parameter">column_name</replaceable>. If you need multiple <type>lo</> columns in the same table, create a separate trigger for each one, remembering to give a different name to each trigger on the same table. |