Re: [HACKERS] Show stopper ? (was: Re: "cruising" or "browsing" through tables using an index / ordering)

On Fri, 23 Jan 1998, Jan Vicherek wrote:

> > You can put an index on the table, and embed a function inside the
> > engine to spin through the index, getting valid rows.
>
>   Aha, this implies that in the index there are valid and non-valid rows.
> I guess those that are to be "valid" (no current transactions on that
> row) and the non-valid "those that are subject to an update lock /
> transaction".

    There is no record level locking available at this point in time,
only table level.  Bruce, just curious...this whole discussion...would it
be moot if we did have record level locking?

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org