Search Postgresql Archives

Re: problem with serial data type and access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux