RE: [INTERFACES] Re: Read-only in MSAccess

I did some brief testing with Access97, the log files did not show any
references to "primary" nor "foreign".  I would to know if it is possible to
get Access to ask the server what the primary keys are?  I know there is an
ODBC function call that an application can use to see what functionality the
driver supports.  I wonder how this called is being handled in the postgres
ODBC driver?  I am sure I will be doing a lot more testing on this in the
near future.

    -----Original Message-----
    From:    Ross J. Reedstrom [SMTP:reedstrm@rice.edu]
    Sent:    Monday, March 08, 1999 3:05 PM
    To:    pgsql-interfaces@postgreSQL.org
    Subject:    Re: [INTERFACES] Re: Read-only in MSAccess

    I've noticed this affect. Has anyone run traces of the connection,
to
    see if Access tries to determine the primary key from the backend?
Does
    this requirement go away if you (manually) set the 'relhaspkey' bool
in
    pg_class for the table?  I'd do all this testing myself, but my NT
test
    box got taken away (yeay! boo! I'm so conflicted...)

    Ross

    Ben Gunter wrote:
    >
    > (Original message was lost.  Oops.)
    >
    > I was fiddling around with Access and the ODBC driver this morning
and
    > discovered that Access will not allow you update ODBC sources
unless you pick
    > at least one field (up to ten) as a unique index.  Otherwise, it's
read-only.
    >
    > Hope this helps.
    >
    > -Ben

    --
    Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
    NSBRI Research Scientist/Programmer
    Computer and Information Technology Institute
    Rice University, 6100 S. Main St.,  Houston, TX 77005