ODBC driver issue in MS Access - Mailing list pgsql-hackers

From Patrick Dunford
Subject ODBC driver issue in MS Access
Date
Msg-id 001001c093ce$41a43340$d084a7cb@patrickspc
Whole thread Raw
List pgsql-hackers
I installed the ODBC driver for Postgre, and linked in a table which has a
Serial field for the primary key. In MS Access, the type is shown as just
"Number (long integer)".

When I try to add new records to my database in Access, I don't put anything
into the key field because the server is supposed to generate it
automatically. But when my record is sent back to the server, it rejects it
and Access displays "#Deleted" in all of the fields. Is this because Postgre
can't fill in the key field and so rejects it as an integrity constraint
violation? I don't get any errors from Access.

Should my database create its own key values and store them itself?

=======================================================================
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
  In this way, love is made complete among us so that we will have
confidence on the day of judgment, because in this world we are
like him.   -- 1 John 4:17
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010210
=======================================================================
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ODBC] RE: [PATCHES] Fix for ODBC close
Next
From: Bruce Momjian
Date:
Subject: ODBC backward versions