- publishing free software manuals
PostgreSQL Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
ISBN 0954612035
RRP £19.95 ($34.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

6.2 Visibility of Data Changes

If you execute SQL commands in your trigger function, and these commands access the table that the trigger is for, then you need to be aware of the data visibility rules, because they determine whether these SQL commands will see the data change that the trigger is fired for. Briefly:

Further information about data visibility rules can be found in section 13.4 Visibility of Data Changes. The example in section 6.4 A Complete Example contains a demonstration of these rules.

ISBN 0954612035PostgreSQL Reference Manual - Volume 2 - Programming GuideSee the print edition