RE: FIXED: Cannot INDEX an Access97 ODBC export?
От | lampe@durawebs.com |
---|---|
Тема | RE: FIXED: Cannot INDEX an Access97 ODBC export? |
Дата | |
Msg-id | 001001bfd27e$22c23b50$81321b26@pop обсуждение исходный текст |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: