Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'

On Tue, 12 May 1998, Ewan Mellor wrote:

> Hannu Krosing wrote:
> > 
> > Ewan Mellor wrote:
> > >
> > > I am using Byron's ODBC driver (version .0239 downloaded today) with
> > > Access 7.00 under Win95 with Postgres 6.3.  I am trying to link tables
> > > into Access.  Most tables work fine, but any field with the name 'name'
> > > or 'sortname' or even 'garbagename' may not be used as part of an
> > > index.  This occurs whether the index is picked up automatically by the
> > > driver, or if you are asked to choose a unique field by Access.
> > 
I'm using Byron's ODBC v6.30.0238 with M$-Access-97 under Win95 with
PostgreSQL v6.3. I can successful link tables into M$-Access even if they have
the word 'name' as column name or table name.
M$-Access picked column 'name' as unique index and it seems work. I can
read and write data into may table named 'gname'.
this is my example:

odbc=> create table gname ( name name, pname int);
CREATE
odbc=> insert into gname values ( 'name',1234);
INSERT 528554 1
odbc=> select * from gname;
name|pname
----+-----
name| 1234
(1 row)

odbc=> \d gname

Table    = gname
+-------------------------------+----------------------------------+-------+
|           Field               |              Type                | Length|
+-------------------------------+----------------------------------+-------+
| name                          | name                             |    32 |
| pname                         | int4                             |     4 |
+-------------------------------+----------------------------------+-------+
                                                                Jose'