RE: FIXED: Cannot INDEX an Access97 ODBC export?

Thanks for the info: Appears, unbeknownst to me, that UPPER case field names
can't be addressed via the CREATE INDEX statement in psql mode. Renamed all
my Access97 table field names to "Lower Case" and exported them to the
PostgreSQL 7.0 database. Now they "can" be indexed just fine. Hmmmm.

So, why is that?

DLampe :-)
lampe@durawebs.com

----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: <lampe@durawebs.com>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, June 09, 2000 5:49 PM
Subject: Re: [GENERAL] Cannot INDEX an Access97 ODBC


> <lampe@durawebs.com> writes:
> > The psql CREATE INDEX statement can't see the imported column
> > (name/attribute)... wierd?
>
> I still think that Bryan's got the right idea --- Access probably
> created the column name with some embedded blanks and/or upper-case
> characters, which'd mean that you have to quote the column name in
> order to refer to it.
>
> It would be useful to see the output of
> pg_dump -s -t tablename databasename
> for this table.
>
> regards, tom lane






________________________________________________________
                           1stUp.com - Free the Web
   Get your free Internet access at http://www.1stUp.com