Access and field sizes - Mailing list pgsql-sql

From Andrew Perrin - Demography
Subject Access and field sizes
Date
Msg-id Pine.WNT.4.05.9910251646200.153-100000@random.demog.berkeley.edu
Whole thread Raw
List pgsql-sql
Greetings-

I'm in the process of porting a database from Access to postgres, and have
run into a snag.  The snag involves boolean fields using checkboxes in
Access forms; they always return a useless Microsoftish error:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. 

This happens when a checkbox is clicked to set a boolean value to True,
but not when it is clicked to set the value back to False.

Does anyone have any experience or idea where to go with this?

Thanks-
Andy Perrin

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography    -    University of California at Berkeley
2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199



pgsql-sql by date:

Previous
From: "Zot O'Connor"
Date:
Subject: Re: [SQL] Week of year function?
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Stats on new tables