Re: How to ensure data consistency?
From: ddtl <fake_at_address.com>
Date: Tue, 07 Sep 2004 23:57:10 -0700
Message-ID: <60atj0d0gehh4tunbgijjddetm5jrd26is_at_4ax.com>
Date: Tue, 07 Sep 2004 23:57:10 -0700
Message-ID: <60atj0d0gehh4tunbgijjddetm5jrd26is_at_4ax.com>
>It would be possible, if Postgres supported the ANSI "CREATE
>ASSERTION" statement. Presumably it does not?
No, unfortunately postgresql does not support assertions.
If I understand the idea correctly, when such an assertion is in effect,
entries into the super-table and sub-table can be made only inside
a transaction - otherwise, an attempt to insert a row into the main
table will violate the assertion.
Am I correct?