indexes on functions, then modifying functions - Mailing list pgsql-general

From Costin Manda
Subject indexes on functions, then modifying functions
Date
Msg-id 1359.193.226.119.24.1115291070.squirrel@193.226.119.24
Whole thread Raw
In response to Re: Postgres 8.02 connectivity  (Shaun Clements <ShaunC@relyant.co.za>)
List pgsql-general
  I have a plpgsql function that I am generating from time to time, like
once a week or so. What it does is it compares some phone numbers for
certain prefixes and then outputs the phone numbers without the
prefixes.

   First I tried to make the function read from the database the prefixes,
but when I tried indexing it the whole database crashed (actually it
didn't crash, it just ate all resources on the computer and thus
crippled it).

   So the solution I opted for is to recreate the function from time to
time, considering that there is a small number of such prefixes to be
removed.

   My question is: what happends if I index this function, then I change
it? Does the index automatically recomputes itself or do I have to
reindex manually?

   Thank you!


-------------------------
E-Mail powered by MadNet.
http://www.madnet.ro/


pgsql-general by date:

Previous
From: Shaun Clements
Date:
Subject: Re: Postgres 8.02 connectivity
Next
From: Mage
Date:
Subject: Re: plpython bug