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

From Adrian Klaver
Subject Re: problem with serial data type and access
Date
Msg-id 200805160718.43670.aklaver@comcast.net
Whole thread Raw
In response to Re: problem with serial data type and access  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
On Thursday 15 May 2008 11:44 pm, Ottavio Campana wrote:
> Adrian Klaver ha scritto:
> >> The fact is that the serial data type is in pratice an integer, and when
> >> I also try to connect with pgadminIII I see an integer data type and not
> >> a serial. I think that since it sees an integer, it does not understand
> >> that it is a serial, and access does not recognize it as autoincrement.
> >>
> >> I'm stuck at this point...
> >
> > Did you mark this field as the primary key when you linked the table?
>
> yes I did

Just out of curiosity, create a test table using the WITH OIDS clause and a
serial data type column along with some test columns and try to INSERT a
record.

--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Next
From: "Richard Broersma"
Date:
Subject: Re: problem with serial data type and access