Re: Cannot INDEX an Access97 ODBC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lampe(at)durawebs(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot INDEX an Access97 ODBC
Date: 2000-06-09 17:49:53
Message-ID: 19808.960572993@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<lampe(at)durawebs(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-06-09 18:14:10 Ah, yet another cause for not binding the right port....
Previous Message NRonayette 2000-06-09 17:03:25 Re: to pass a parameter