Views created by UNION ALL could be updated with both UPDATE and DELETE operations. They are just transformed to UPDATE/DELETE operation on base tables (or views). I think INSERT cannot be accepted however. For example, suppose we have v1:
CREATE VIEW v1 AS SELECT * FROM t1 UNION ALL SELECT * FROM t2; Inserting into v1 is ambiguous because it can be transformed either inserting into t1 or t2. So I think we could make v1 auto updatable view. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers