Received: from boserup.demog.berkeley.edu (boserup.DEMOG.Berkeley.EDU [128.32.93.12]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA82127 for ; Mon, 25 Oct 1999 19:53:24 -0400 (EDT) (envelope-from aperrin@demog.berkeley.edu) Received: from random.DEMOG.Berkeley.EDU (random.DEMOG.Berkeley.EDU [128.32.93.50]) by boserup.demog.berkeley.edu (8.9.3/8.9.3) with ESMTP id QAA20185 for ; Mon, 25 Oct 1999 16:54:13 -0700 (PDT) Date: Mon, 25 Oct 1999 16:49:07 -0700 (Pacific Daylight Time) From: Andrew Perrin - Demography To: pgsql-sql@postgresql.org Subject: Access and field sizes Message-ID: X-X-Sender: aperrin@email.demog.berkeley.edu MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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