Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add" - Mailing list pgsql-odbc

From Peter Bense
Subject Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"
Date
Msg-id s288ab6d.008@gwm.sc.edu
Whole thread Raw
List 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 by date:

Previous
From: Edzard Pasma
Date:
Subject: Unable to obtain list of tables from the data source
Next
From: Jeff Eckermann
Date:
Subject: Re: Access 2000 bitching... "The field is too small to accept the amount of data you attempted to add"