Robert Creager wrote:
On Mon, 11 Aug 2003 11:05:57 -0400 Tom Lane <[EMAIL PROTECTED]> said something like:
If you really want to rebuild only the one index, I think this will work:
begin; lock table tab; reindex index ndx; commit;
Figures. It appears that DBD::Pg doesn't supported nested transactions (I was already in a transaction).
DBD::Pg::db begin_work failed: Already in a transaction at /tass/bin/importSList.pl line 445.
Unfortunatly, it does take longer overall because of the second index on the table, but it always works ;-) 'Nother duh moment, delete the second index, and then it works just fine speed wise. Guess I need to re-examine my index usage...
Thanks, Rob
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
