[Pkg-postgresql-public] GiST rebuild

[Markus Wanner]

Hi,

Gerfried Fuchs wrote:
>  Is it possible to check for the existence of such indixes before the
> decision is made? Or would it be reduced to a noop when no such indixes
> are there?

The following SQL gets you a list of GiST indices:

 SELECT relname FROM pg_class
   LEFT JOIN pg_am ON relam = pg_am.oid
   WHERE relkind='i' AND amname = 'gist';

So it should easily be possible to reduce this to a no-op if there are
no GiST indices found.

I think a warning is still appropriate, even if no GiST indices could be
found in the managed databases, because the user might have installed
custom databases which pg_*cluster doesn't know about.

Regards

Markus Wanner