On 18 Jun 2002, Jason Earl wrote:
> The script was posted to this list (a search for reindex turned it up
> in my local mirror of the mailing list). If you can't find it feel
> free to contact me.
Oh come now, I troll the list once in a while. I sent a copy to him.
My script doesn't really lock anything, it must just be a natural
side-effect of the REINDEX command, kinda like the old VACUUM in
Postgres < 7.2. I can see why, though. It looks like it drops the
index and then recreates it. Not good for integrity if you don't lock.
Ah well, it'll get fixed eventually. How about postgres 8.9?
^_^
--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Administrator |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas@townnews.com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+