Thread: ODBC Driver not allowing updates into views
Hi, I am using Postgres 9.3.2 and the application I am working on requires upda= ting views, inserting into views and delete from views. None of these opera= tion are working from ODBC. The same are possible when connecting to the database via JDBC or psql. NB: I am not part of any of the email lists. Thanks and Regards, Firas Khasawneh
On 2/7/2014 8:51 AM, Firas Khasawneh wrote: > > I am using Postgres 9.3.2 and the application I am working on requires > updating views, inserting into views and delete from views. None of > these operation are working from ODBC. > > The same are possible when connecting to the database via JDBC or psql. > Writable views is a fairly new feature in PostgreSQL, added in 9.3, I'm guessing the ODBC drivers haven't caught up with this yet. It would be helpful to know what sort of ODBC driver you're using... there's ODBC on Unix systems, and Microsoft Windows ODBC, and I believe there's a couple different implementations of the PostgreSQL ODBC drivers for each of these environments.. Those ODBC drivers are not part of the core PostgreSQL project, and likely have their own bug lists. (please reply to pgsql-bugs rather than me directly). -- john r pierce 37N 122W somewhere on the middle of the left coast
I am using Postgres 93 ODBC on Centos. so hopefully this is the latest. Thi= s is not an issue in JDBC but it seems a problem only in ODBC. If anybody h= ave any suggestion or if Postgres is going to provide this feature that wou= ld be very helpful. We are at a point where we are dropping Postgres suppor= t from our product because of this. From: John R Pierce [mailto:pierce@hogranch.com] Sent: Friday, February 07, 2014 3:45 PM To: Firas Khasawneh Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] ODBC Driver not allowing updates into views On 2/7/2014 8:51 AM, Firas Khasawneh wrote: I am using Postgres 9.3.2 and the application I am working on requires upda= ting views, inserting into views and delete from views. None of these opera= tion are working from ODBC. The same are possible when connecting to the database via JDBC or psql. Writable views is a fairly new feature in PostgreSQL, added in 9.3, I'm gue= ssing the ODBC drivers haven't caught up with this yet. It would be helpful to know what sort of ODBC driver you're using... there= 's ODBC on Unix systems, and Microsoft Windows ODBC, and I believe there's = a couple different implementations of the PostgreSQL ODBC drivers for each = of these environments.. Those ODBC drivers are not part of the core Postg= reSQL project, and likely have their own bug lists. (please reply to pgsql-bugs rather than me directly). -- john r pierce 37N 122W somewhere on the middle of the left coast
On Sun, Feb 9, 2014 at 1:50 AM, Firas Khasawneh <Firas.Khasawneh@sas.com>wrote: > I am using Postgres 93 ODBC on Centos. so hopefully this is the latest. > This is not an issue in JDBC but it seems a problem only in ODBC. If > anybody have any suggestion or if Postgres is going to provide this feature > that would be very helpful. We are at a point where we are dropping > Postgres support from our product because of this. > Can you please post your question to the odbc mailing list - pgsql-odbc@postgresql.org. -- Regards, Hari Babu Fujitsu Australia Software Technology
Hari, I sent it to postg From: Haribabu Kommi [mailto:kommi.haribabu@gmail.com] Sent: Sunday, February 09, 2014 10:01 PM To: Firas Khasawneh Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] ODBC Driver not allowing updates into views On Sun, Feb 9, 2014 at 1:50 AM, Firas Khasawneh <Firas.Khasawneh@sas.com<ma= ilto:Firas.Khasawneh@sas.com>> wrote: I am using Postgres 93 ODBC on Centos. so hopefully this is the latest. Thi= s is not an issue in JDBC but it seems a problem only in ODBC. If anybody h= ave any suggestion or if Postgres is going to provide this feature that wou= ld be very helpful. We are at a point where we are dropping Postgres suppor= t from our product because of this. Can you please post your question to the odbc mailing list - pgsql-odbc@pos= tgresql.org<mailto:pgsql-odbc@postgresql.org>. -- Regards, Hari Babu Fujitsu Australia Software Technology