Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL and ACID properties support - Mailing list pgsql-general

From Stephan Szabo
Subject Re: PostgreSQL and ACID properties support
Date
Msg-id 20030809103107.I11786-100000@megazone.bigpanda.com
Whole thread Raw
In response to PostgreSQL and ACID properties support  (nzanella@cs.mun.ca (Neil Zanella))
List pgsql-general
Tree view 
On 7 Aug 2003, Neil Zanella wrote:

> of transactions as opposed to the operations taking place serially? Also, does
> PostgreSQL fully support SQL99 CHECK constraints? And if the system crashes...

Technically no. Check constraints with subselects are not supported.
Using a function gets you half the constraint, but doesn't notice
modifications to the other table(s) involved.  You might need triggers
to handle that portion.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: FATAL: The database system is in recovery mode
Next
From: Christopher Browne
Date:
Subject: Re: postmaster(s) have high load average