TODO item

On Jue 05 Jul 2001 00:30, you wrote:

Mart�n Marqu�s writes:

The other is related to indexes on databases other then initiated with C
locale. The docs say that those databases don't use the indexes on
sequencial searches. Is this right?

The database never uses indexes on sequential searches, by definition.
You must be talking about the LIKE optimization issue. That is very hard
to fix, in my estimate.

My mistake. Yes the LIKE and regexp searches is what I wanted to say.

Saludos... :-)

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Mart�n Marqu�s writes:

The other is related to indexes on databases other then initiated with C
locale. The docs say that those databases don't use the indexes on sequencial
searches. Is this right?

The database never uses indexes on sequential searches, by definition.
You must be talking about the LIKE optimization issue. That is very hard
to fix, in my estimate.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

On Wed, 4 Jul 2001, [iso-8859-1] Mart���n Marqu���s wrote:

I was thinking about a par of things that I think are quite interesting for
the 7.2 release.

The first one is related to a problem I had with views and rules (permission
problem). If someone is granted insert on a view with his respective rule,
won't be able to insert a row if there is a sequence (SERIAL type), saying
that the user doesn't have permission to change the sequence.

Essentially, sequence is treated as a separate table for purposes of
permission checking. Its probably _not very hard_ to fix, by forcing check
of the underlying relation instead of check of sequence itself...Whether
its a right thing to do, I'm not sure.

The other is related to indexes on databases other then initiated with C
locale. The docs say that those databases don't use the indexes on sequencial
searches. Is this right?

Only queries using LIKE 'foo%', cannot use indices.

Reason: you don't know what foo will collate in different locale, i.e.
there may be foo with umlaut o, which _should_ match 'foo', but you cannot
index this kind of a search...