pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
5+ messages / 4 participants
[nested] [flat]
* BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
@ 2024-03-28 23:27 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Bug reporting form @ 2024-03-28 23:27 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: nia@p1.tcnet.ne.jp
The following bug has been logged on the website:
Bug reference: 18416
Logged by: norihiro kawagoshi
Email address: nia@p1.tcnet.ne.jp
PostgreSQL version: 14.6
Operating system: Windows10
Description:
I apologize for the inconvenience, but I would like to request your
assistance in checking an issue related to the PostgreSQL ODBC.
Our current environment is as follows:
OS：Windows10
PostgreSQL version： 14.7
ODBC version：PostgreSQL Unicode 16.00
SOFT:Microsoft ACCESS for office 365 (16.012624.20422) 32Bit
am reaching out to you regarding an issue I have encountered while using
Microsoft Access to create a linked table to a PostgreSQL VIEW and
executing
a specific SQL query, which resulted in an error. I would like to inquire
about the cause of this error.
The SQL query that generates the error is as follows:
SELECT left(tseisan_v_test_a.[A1],3) AS leftkansu, tseisan_v_test_b.[A1]
FROM tseisan_v_test_a LEFT JOIN tseisan_v_test_b ON tseisan_v_test_a.[A1]
=
tseisan_v_test_b.[A1]
WHERE left(tseisan_v_test_a.[A1],3)='110';
When I execute the above query, I receive the following error message:
"ODBC--call failed. ERROR: syntax error at or near ")"; Error while
executing the query (#1)."
I have confirmed that the condition WHERE
left(tseisan_v_test_a.[A1],3)='110' executes correctly without the LEFT
JOIN. However, when I try to use the LEFT or RIGHT functions after
performing a LEFT JOIN, an error occurs. On the other hand, I have
verified
that the MID function can be used without issues. Additionally, I have
confirmed that the same SQL statement does not generate an error when
processed in PGADMIN, suggesting that the problem may be specific to
Access.
I suspect that the ODBC driver may not be able to interpret the use of the
LEFT function within the WHERE clause following a LEFT JOIN. If the
problem
lies with the ODBC driver, I kindly request that it be corrected.
I appreciate your attention to this matter and look forward to your prompt
response.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
@ 2024-03-29 08:57 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2024-03-29 08:57 UTC (permalink / raw)
To: nia@p1.tcnet.ne.jp; pgsql-bugs@lists.postgresql.org
On Thu, 2024-03-28 at 23:27 +0000, PG Bug reporting form wrote:
> I apologize for the inconvenience, but I would like to request your
> assistance in checking an issue related to the PostgreSQL ODBC.
There is a special mailing list pgsql-odbc for the ODBC driver.
To narrow down the problem, use the logging parameters of the ODBC
driver to capture the actual SQL statement executed.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
@ 2024-04-01 00:22 あ <nia@p1.tcnet.ne.jp>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 5+ messages in thread
From: あ @ 2024-04-01 00:22 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Thank you for your response. Should I proceed with logging for the ODBC driver and then re-inquire on the pgsql-odbc mailing list?
Windows の メール から送信
差出人: Laurenz Albe
送信日時: 2024年3月29日 17:57
宛先: nia@p1.tcnet.ne.jp; pgsql-bugs@lists.postgresql.org
件名: Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
On Thu, 2024-03-28 at 23:27 +0000, PG Bug reporting form wrote:
> I apologize for the inconvenience, but I would like to request your
> assistance in checking an issue related to the PostgreSQL ODBC.
There is a special mailing list pgsql-odbc for the ODBC driver.
To narrow down the problem, use the logging parameters of the ODBC
driver to capture the actual SQL statement executed.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
@ 2024-04-02 08:04 Laurenz Albe <laurenz.albe@cybertec.at>
parent: あ <nia@p1.tcnet.ne.jp>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2024-04-02 08:04 UTC (permalink / raw)
To: あ <nia@p1.tcnet.ne.jp>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Mon, 2024-04-01 at 09:22 +0900, あ wrote:
> Thank you for your response. Should I proceed with logging for the ODBC driver
> and then re-inquire on the pgsql-odbc mailing list?
Yes, that was what I was suggesting.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
@ 2024-04-02 10:56 ケーブル <nia@p1.tcnet.ne.jp>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 5+ messages in thread
From: ケーブル @ 2024-04-02 10:56 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-bugs@lists.postgresql.org
Thank you for your response.
I will check with the PGSQL-ODBC mailing list.
Thank you very much.
iPhoneから送信
> 2024/04/02 17:04、Laurenz Albe <laurenz.albe@cybertec.at>のメール:
>
> On Mon, 2024-04-01 at 09:22 +0900, あ wrote:
>> Thank you for your response. Should I proceed with logging for the ODBC driver
>> and then re-inquire on the pgsql-odbc mailing list?
>
> Yes, that was what I was suggesting.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-04-02 10:56 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-28 23:27 BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows PG Bug reporting form <noreply@postgresql.org>
2024-03-29 08:57 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-04-01 00:22 ` あ <nia@p1.tcnet.ne.jp>
2024-04-02 08:04 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-04-02 10:56 ` ケーブル <nia@p1.tcnet.ne.jp>
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