Re: problem with serial data type and access

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: problem with serial data type and access
Дата
Msg-id 200805160718.43670.aklaver@comcast.net
обсуждение исходный текст
Ответ на Re: problem with serial data type and access  (Ottavio Campana <ottavio@campana.vi.it>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Следующее
От: "Richard Broersma"
Дата:
Сообщение: Re: problem with serial data type and access