Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"

Поиск
Список
Период
Сортировка
От Peter Bense
Тема Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"
Дата
Msg-id s288ab6d.008@gwm.sc.edu
обсуждение исходный текст
Список pgsql-odbc
I am getting a

"The field is too small to accept the amount of data you attempted to
add" postgresql error when attempting to enter data into the following
linked table in MS-Access.  Nothing seems to be out of range.  Any
ideas?:

CREATE TABLE tblpis_survey_receipt (
    insertion SERIAL,
    ppt_id INT4 NOT NULL,
    date_received DATE NOT NULL,
    staff_id INT4 NOT NULL,
    survey_type INT2 NOT NULL,
    is_blank BOOL NOT NULL,
    birth_month INT2,
    birth_year INT2,
    check_ppt BOOL NOT NULL,
    check_dob BOOL NOT NULL,
    check_tracking BOOL NOT NULL,
    date_inserted TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    date_modified TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    PRIMARY KEY (insertion)
);


Peter T. Bense - Teradata Certified Professional
(ptbense@gwm.sc.edu) - 803-777-9476
Database Administrator/Webmaster
Prevention Research Center
University of South Carolina

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Edzard Pasma
Дата:
Сообщение: Unable to obtain list of tables from the data source
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"