From: 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: PostgreSQL: Inserting NULL values adds empty string.
Date: Sun, 14 Feb 2016 13:13:13 +0000
Message-ID: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-odbc>
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 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.
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
-----Original Message-----
From: Venkatesan, Sekhar
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 doesnt work!!!
HI Joshua,
I perform the following set of operations to set autocommit in postgreSQL through ODBC in windows.
SQLSetConnectAttr(hDbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER) SQL_AUTOCOMMIT_ON, 0)
ret = SQLDriverConnect(_hdbc, NULL, (SQLCHAR*) dsn.GetChars(), SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);
This doesn't enable autocommit. If I call SQLSetConnectAttr after SQLDriverConnect, autocommit is set.
Any issue with this sequence? I assume It should be possible to set SQL_ATTR_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 doesnt 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
> 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 any.
>
By default PostgreSQL "autocommits". If it isn't in your case, your driver is starting a transaction and not committing it.
Sincerely,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
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: sekhar.venkatesan@emc.com, pgsql-odbc@postgresql.org
Subject: Re: PostgreSQL: Inserting NULL values adds empty string.
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C66716D@MX105CL01.corp.emc.com>
* 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