On 11/24/13, 10:03 AM, Simon Riggs wrote: > So we'd need to get access to the changed rows, rather than > re-executing a huge SQL command that re-checks every row of the table. > That last point will make it unusable for sensible amounts of data.
SQL assertions work with arbitrary expressions. So even if you had the changed rows, you couldn't do anything with them in general. For cases where it makes sense to consider the changed rows, you probably want a per-table trigger or an exclusion constraint or perhaps an auto-updated materialized view. Then again, we have lots of ways to make queries fast even for large tables. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers