Re: comparision chart - Mailing list pgsql-sql

From Brian Knox
Subject Re: comparision chart
Date
Msg-id Pine.LNX.4.40.0202210913380.4510-100000@tao.office.aol.com
Whole thread Raw
In response to Re: comparision chart  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
What is the definition of 'hotback' in this case? I thought that you could
run pg_dump to dump a database while it was being actively used... could
you give more information as to why you say that postgres does not support
hot backups?

On Wed, 20 Feb 2002, Josh Berkus wrote:

> Clayton,
>
> >
> > Database    MySQL    Postgresql    Oracle
> > Transactions    Partial    Yes    Yes
> > RowLock    No    Yes    Yes
> > Constraints    No    Partial    Yes
> > Programmable    Partial    Yes    Yes
> > Secure    Yes    Yes    Yes
> > FailSafe    No    Yes    Yes
> > Hotback    No     No    Yes
>
> SQL-92 Compliance   50%    85%    75%  (very rough estimate)
>
> Regarding your rating of Postgres, what do you mean by "partial"
>  support of constraints?  And what is "hotBack"?
>
> -Josh
>
>
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>



pgsql-sql by date:

Previous
From: Henry Holland
Date:
Subject: Changing column constraints?
Next
From: "Hano de la Rouviere"
Date:
Subject: Re: trigger on table