Access and Boolean - Mailing list pgsql-general

From Hauke de Vries
Subject Access and Boolean
Date
Msg-id 3C0F97B0.20832.FE288DD@localhost
Whole thread Raw
In response to Re: Number of Connections  (Eric Crampton <eric@atdesk.com>)
Responses Re: Access and Boolean
List pgsql-general
I've imported some Access tables into PostgreSQL and Would like to
use Access as frontend with linked tables.

For modifying, updating, appending we use a form. Some fields have
Boolean values (default 0). In Access this is expressed as '=No'.
If we want it marked, i.e. set 'field' to 1, Access returns "The
field is too small to accept the amount of data you are trying to
add. Try inserting or paste less data."

This is a remarkable 'feature' of Access returning -1 upon clicking.
How to circumvent this behaviour?

Hauke de Vries

pgsql-general by date:

Previous
From: "Carsten Gerhardt"
Date:
Subject: Re: When do I Vacuum ?
Next
From: "john"
Date:
Subject: postgresql startup problem