Postgres Pro
Downloads
Home   >   mailing lists

Thread: TODO item

TODO item

From
Martín Marqués
Date:
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.

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?

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
-----------------------------------------------------------------

Re: TODO item

From
Peter Eisentraut
Date:
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

Re: TODO item

From
Martín Marqués
Date:
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
-----------------------------------------------------------------

Re: TODO item

From
Alex Pilosov
Date:
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...