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 9:14 am, Ottavio Campana wrote:
> Scott Marlowe ha scritto:
> > On Thu, May 15, 2008 at 7:54 AM, Ottavio Campana <ottavio@xxxxxxxxxxxxx> 
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???
>
> I'd like to, but I don't think I could do it.
>
> 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?

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