Re: Create index in PG table with vb6

Hmm, looks like Yahoo crapped out on me and failed to
send the text of my reply (that's my story and I'm
sticking to it ;-) ). Trying again:

Sounds like your problem field is type text, and your
ODBC driver setting for "Text As LongVarChar" is
"true". Access will see the field as "memo" type in
that case, and therefore not indexable or searchable.

You could redefine your field as varchar, or unset the
driver option, though that will mean a size limitation
on your fields.

--- Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> wrote:
> --- DanPerlman <dan(at)dpci(dot)us> wrote:
> > Hi,
> >
> > I am using the following to write data from an
> > access table to a postgres
> > table.
> > I need to create an index on the
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com