From: "Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: PostgreSQL: Inserting NULL values adds empty string.
Thread-Topic: PostgreSQL: Inserting NULL values adds empty string.
Thread-Index: AdFnKHSBhR/6qCaDR/mlfXFjFt8rAw==
Date: Sun, 14 Feb 2016 13:13:13 +0000
Message-ID: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-odbc-owner@postgresql.org

Hi Folks,

I am using PostgreSQL 9.4 odbc driver to talk to 9.4 postgreSQL server.
I see that when inserting NULL values into DB is adding empty  string in th=
e database only in windows.
The same insert is adding NULL values into database when linux odbc driver =
is used to connect to linux database.
 Is there any configuration in odbc driver end or in server to retain the n=
ull values or is it a bug?
If it is not and is an expected behavior, how to fix it in the application?

Thanks,
Sekhar

-----Original Message-----
From: Venkatesan, Sekhar=20
Sent: Friday, January 29, 2016 10:04 AM
To: 'Joshua D. Drake'; 'pgsql-odbc@postgresql.org'
Subject: RE: [ODBC] PostgreSQL: Autocommit through windows odbc driver does=
nt work!!!

HI Joshua,

I perform the following set of operations to set autocommit in postgreSQL t=
hrough ODBC in windows.
SQLSetConnectAttr(hDbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER) SQL_AUTOCOMMIT_ON=
,  0)

ret =3D SQLDriverConnect(_hdbc, NULL, (SQLCHAR*) dsn.GetChars(), SQL_NTS, N=
ULL, 0, NULL, SQL_DRIVER_NOPROMPT);

This doesn't enable autocommit. If I call SQLSetConnectAttr after SQLDriver=
Connect, autocommit is set.
Any issue with this sequence? I assume It should be possible to set SQL_ATT=
R_AUTOCOMMIT before establishing connection.
Can you please confirm on this behavior?

Thanks,
Sekhar

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Thursday, January 28, 2016 11:14 PM
To: Venkatesan, Sekhar; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] PostgreSQL: Autocommit through windows odbc driver does=
nt work!!!

On 01/28/2016 08:53 AM, Venkatesan, Sekhar wrote:

> Is the above issue fixed? Also in my use-case, I want to enable=20
> autocommit at odbc driver level but even that doesn't work.
>
> The same application works in Linux OS when unix odbc driver is used.
> This seems to be specific to windows driver.
>
> Please shed some light on this. Do ask me further question if you have an=
y.
>

By default PostgreSQL "autocommits". If it isn't in your case, your driver =
is starting a transaction and not committing it.

Sincerely,

JD


--=20
Command Prompt, Inc.                  http://the.postgres.company/
                      +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc