Re: problem with serial data type and access - Mailing list pgsql-general

From Scott Marlowe
Subject Re: problem with serial data type and access
Date
Msg-id dcc563d10805150858x2e6b7978hd873e08f4bbc03ca@mail.gmail.com
Whole thread Raw
In response to problem with serial data type and access  (Ottavio Campana <ottavio@campana.vi.it>)
Responses Re: problem with serial data type and access  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
On Thu, May 15, 2008 at 7:54 AM, Ottavio Campana <ottavio@campana.vi.it> wrote:
> I know it's not fully IT with the list, but maybe somebody can help me.
>
> I'm dealing with this scenario: access 97 is connected through odbc to a
> postgresql server. All tables are saved in postgresql and access is used
> only to generated the program interface.
>
> Everything works fines, but I'm having problems with the serial data type. I
> know a serial is an integer having as default the next value of a sequence.
> Since it is an integer, access does not recognize it as an autoincrement
> value, and it asks for is value.
>
> Did anyone of you already have this problem?

Can you feed it a value of DEFAULT???

pgsql-general by date:

Previous
From: Steve Manes
Date:
Subject: Re: Password safe web application with postgre
Next
From: "Scott Marlowe"
Date:
Subject: Re: postgres crash when select a record