temp table indexes

Hi,

We are using Postgres 7.1.3.

I am trying to get postgres to use an index that is created on a temp table. The temp table and index is created and loaded from within a plpgsql proc. The select I am trying to force a keyed select on, is also in the same proc.

I have tired SET ENABLE_SEQSCAN TO Off But it still does table scans.

If I create the same temp table from an odbc driven windows sql app like WinSQL lite, I can force an index read if I vacuum the temp table once loaded. I have tired vacuuming the table from within the plpgsql proc, but that seems to cause postgres to shut down.

Can anyone help me here?

Thanks

Andrew