Re: problem with serial data type and access

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???