Re: Firebird and PostgreSQL at the DB Corral. - Mailing list pgsql-general

From Paul Thomas
Subject Re: Firebird and PostgreSQL at the DB Corral.
Date
Msg-id 20031217001341.A30247@bacon
Whole thread Raw
In response to Firebird and PostgreSQL at the DB Corral.  (Paul Ganainm <paulsnewsgroups@hotmail.com>)
List pgsql-general
On 16/12/2003 21:04 Paul Ganainm wrote:
Hi Paul,

> -----------------------
> > Better than row-level locking
>
> X (I assume that what is meant here is MVCC?)
> ------------------------

One thing I couldn't find when looking at the FB on-line docs a week or
two ago was anything like support for transaction isolation level
serializable. Whilst the PG docs states taht its implementation of t.i.l.s
is not quite to SQL spec, it is still very good as you don't need to lock
rows with select ... for update. How does FB do in this respect?

> ------------------------
> > Functional and Partial indexes
>
> O
> --------------------------

No partial indexes? Get them to put it on their TODO list ;)

BTW, has FB got an equivalent of PG sequences?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Dev
Date:
Subject: Join Issues
Next
From: Bruce Momjian
Date:
Subject: Re: UTF support in WIN32 native and Lower/Upper in 7.5 release