Orlando Andico writes:
> On Thu, 6 Apr 2000, brianb wrote:
> ..
> > PostgreSQL is a full featured RDBMS that supports transactions, subselects,
> > views and (coming soon) outer joins. It's much closer to fulfulling the
> > ACID requirements than MySQL is, but it's not quite there yet either (it's
> > missing the C), as of 6.5.*.
>
> consistency? I though PG had multiversioning?
It does, and it works. Multiversioning is a prerequisite for the I
(Isolation) and A (Atomicity) unless you like doing table locks.
Consistency is being able to designate foreign keys. It can be done using
triggers, but ideally you should be able to tell it what the foreign keys
are in your DDL.
Note that your previous comments about the stability problems of Postgres
are correct...if you're using 6.4 or earlier. The 6.5.* series is a major
improvement in stability and performance, and it looks like the 7 release
is going to be another major leap forward.
> With the costing of Oracle Workgroup Server nowadays, I'd recommend you
> buy it if your data is worth anything (e.g. company records, etc). You can
> come in under 30K (pesos) for a 5-seat license. Thats cheaper than MS SQL
> 7.0 and I'd put my money on Oracle..
Same here.
Brian
--
Brian Baquiran <[EMAIL PROTECTED]>
http://www.baquiran.com/
AIM: bbaquiran
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
