Skip site navigation (1) Skip section navigation (2)

Re: Either I broke PostgreSQL or I found an ODBC bug

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: Postgresql ODBC List <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Either I broke PostgreSQL or I found an ODBC bug
Date: 2007-11-07 12:15:37
Message-ID: 14958.25889.qm@web31808.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- On Tue, 11/6/07, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:

> 	Unfortunately, Access 95 onwards do not permit Null values in
> 	Yes/No fields.

That explains why I was see FALSE instead of NULL.  As a work around, I've altered all of the boolean fields to be NOT NULL with a DEFAULT value as FALSE.  Now MS-access is able to update these records without complaining.

Thanks!
Regards,
Richard Broersma Jr.

In response to

pgsql-odbc by date

Next:From: Сергей ДемьяненкоDate: 2007-11-08 08:54:48
Subject: Re: Access violation in psqlodbcw.dll
Previous:From: Hiroshi InoueDate: 2007-11-07 08:14:51
Subject: Re: Access violation in psqlodbcw.dll

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group