From: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | Ewan Mellor <em(at)nexus(dot)co(dot)uk> |
Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name' |
Date: | 1998-05-13 10:13:20 |
Message-ID: | Pine.LNX.3.96.980513100530.510C-100000@proxy.bazzanese.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
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'
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-05-13 14:42:29 | Re: [HACKERS] core dump during initdb |
Previous Message | Jose' Soares Da Silva | 1998-05-13 09:55:01 | Re: [HACKERS] money or dollar type |
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-05-13 11:47:54 | Accessing PgSql-Database from NT (ODBCD) |
Previous Message | Ewan Mellor | 1998-05-12 18:17:35 | Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name' |