agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Venkatesan, Sekhar <sekhar.venkatesan@emc.com>
To: pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
Date: Sun, 14 Feb 2016 10:36:36 -0800
Message-ID: <56C0C934.7030403@aklaver.com> (raw)
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
<56C0AFEF.70103@aklaver.com>
<F84DE43FDACD4C45AA84E2DA016FAE2F1C6671BE@MX105CL01.corp.emc.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-odbc>
On 02/14/2016 10:08 AM, Venkatesan, Sekhar wrote:
> It's a C++ application that talks to PostgreSQL DB. I checked the value in database directly.
Just notice this has been cross-posted to --sql, it is generally
considered good etiquette to not do that.
What exact version of psqlodbc are you using?
Does the C++ application you mention run on both Linux and Windows?
Or to put it another way, what is the program flow that gets the data
into the database from Windows versus Linux?
Also are we talking about one Postgres database, or one on Windows and
one on Linux?
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
> Sent: Sunday, February 14, 2016 10:19 PM
> To: Venkatesan, Sekhar; pgsql-odbc@postgresql.org; pgsql-sql@postgresql.org
> Subject: Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string.
>
> On 02/14/2016 05:13 AM, Venkatesan, Sekhar wrote:
>> Hi Folks,
>>
>> I am using PostgreSQL 9.4 odbc driver to talk to 9.4 postgreSQL server.
>
> Through what application?
>
>> I see that when inserting NULL values into DB is adding empty string in the database only in windows.
>> The same insert is adding NULL values into database when linux odbc driver is used to connect to linux database.
>
> How are you determining this?
>
>> Is there any configuration in odbc driver end or in server to retain the null values or is it a bug?
>> If it is not and is an expected behavior, how to fix it in the application?
>>
>> Thanks,
>> Sekhar
>>
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
view thread (6+ messages) latest in thread
Message-ID: <56C0C934.7030403@aklaver.com>
Permalink: ../56C0C934.7030403@aklaver.com/
Also on: postgresql.org/message-id/56C0C934.7030403@aklaver.com
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, sekhar.venkatesan@emc.com, pgsql-odbc@postgresql.org
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
In-Reply-To: <56C0C934.7030403@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox