pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Juarez Rudsatz <juarez@correio.com>
To: pgsql-sql@hub.org
Subject: Re: pgsql-sql-digest V1 #393
Date: Tue, 26 Oct 1999 09:16:08 -0200
Message-ID: <000901bf1fa3$80f2f680$270110ac@psmi.intranet> (raw)
References: <199910260300.XAA06890@hub.org>
> Date: Mon, 25 Oct 1999 16:49:07 -0700 (Pacific Daylight Time)
> From: Andrew Perrin - Demography <aperrin@demog.berkeley.edu>
> Subject: Access and field sizes
>
> 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
>
Recently I has a little problem with boolean fields in ODBC access to
postgres. The type of field was char. In the ODBC driver configuration there
are a advanced option : "Bool as char". Take a look.
Juarez Rudsatz
Message-ID: <000901bf1fa3$80f2f680$270110ac@psmi.intranet> Permalink: ../000901bf1fa3$80f2f680$270110ac@psmi.intranet/ Also on: postgresql.org/message-id/000901bf1fa3$80f2f680$270110ac@psmi.intranet ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-sql@postgresql.org Cc: juarez@correio.com, pgsql-sql@hub.org Subject: Re: pgsql-sql-digest V1 #393 In-Reply-To: <000901bf1fa3$80f2f680$270110ac@psmi.intranet> References: <199910260300.XAA06890@hub.org> <000901bf1fa3$80f2f680$270110ac@psmi.intranet> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox