Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to ensure data consistency?

Re: How to ensure data consistency?

From: ddtl <fake_at_address.com>
Date: Tue, 07 Sep 2004 23:57:10 -0700
Message-ID: <60atj0d0gehh4tunbgijjddetm5jrd26is@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?
Received on Wed Sep 08 2004 - 01:57:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US