Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Olagoke Akinyemi <[email protected]> Thu, 15 Aug 2019 10:54:19 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_7808697_1640599030.1565866459616
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hello,
I need guidance on sending notification (data) to a soap server when transa=
ction occur in PostgreSQL server? How can I accompany this?
Your help will be highly appreciated.
Thank you.
Regards,Sahoong
On Wednesday, 14 August 2019, 21:10:32 BST, Scott Goley <scottmgoley@gm=
ail.com> wrote: =20
=20
Hiroshi,=20
I'm happy to say that this has reflected a massive improvement in performan=
ce for this connector / driver.=20
Thank you very much!
I can tell there are some edge cases which are not working as expected but =
in general this meets my very high level requirements. Let me take a few da=
ys to isolate these particular issues remaining with reproducible condition=
s before sending you further logs.=20
I am most grateful.=20
Scott
On Aug 14 2019, at 10:24 am, Inoue, Hiroshi <[email protected]> wro=
te:
Oops sorry,The error was caused by changes about another problem.
Could you please try the test drivers on Windows 11.00.0320 athttps://winpg=
.jp/~inoue/psqlodbc/index.html?
regards,Hiroshi Inoue
On 2019/08/14 22:22, Scott Goley wrote:
Hiroshi,
I'm afraid this version has broken my ability to make a connection so I am =
unable to verify the rest of the changes. This is after verifying the drive=
r updated correctly and is showing on the logs as "11.01.0310"
Best regards,Scott
On Aug 14 2019, at 6:49 am, Inoue, Hiroshi <[email protected]> wrot=
e:
Hi Scott,
Could you please try the test drivers on Windows 11.00.0310 athttps://winpg=
.jp/~inoue/psqlodbc/index.html?
regards,Hiroshi Inoue
On 2019/08/13 23:27, Scott Goley wrote:
Hiroshi - my apologies. I believe that I did not appropriately remove the o=
ld version prior to adding this one to my system:
This is the correct result for that version of the driver:
The other mylog file is over 25mb. As a result, I'm sharing with you via a =
dropbox link:
https://www.dropbox.com/s/iwff1b3dl36forr/mylog_Microsoft_22916.log?dl=3D0T=
hank you very much for your quick assistance - I now see the driver attempt=
ing to cast via an interval on date fields.
Best,Scott
On Aug 13 2019, at 8:46 am, Scott Goley <[email protected]> wrote:
Hi Hiroshi,
Thank you for your response. I am not currently observing any change betwee=
n this version and the previous version used. Please see the attached.
Best,Scott
On Aug 12 2019, at 6:44 am, Inoue, Hiroshi <[email protected]> wrot=
e:
Hi Scott,
Could you please try the test drivers 11.00.0200 on Windows athttps://winpg=
.jp/~inoue/psqlodbc/index.html?
regards,Hiroshi Inoue
On 2019/08/11 7:51, Scott Goley wrote:
Hiroshi,
Thank you for your response. I will definitely look into that.
Is there any resource which specifies what functions and flags are supporte=
d via the current psqlODBC driver?=C2=A0 That would be extremely helpful to=
me if you were aware of one.
Best,Scott G
On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi <[email protected]> wrote=
:
Hi Scott,
Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is supported now.C=
ould you please try test drivers which would support them?
regards,Hiroshi Inoue
On 2019/08/09 0:00, Scott Goley wrote:
Hi,
Platform / Version info:
Postgres 11.4psqlODBC_x64 v 11.01.0000
I'm a developer working with PowerQuery / ODBC and I'm running into the fol=
lowing issue.
I'm developing a custom connector which is utilizing this driver. I've atta=
ched the logs as requested when making a bug report. It looks like the SQL_=
TSI_DAY operator is being "interpreted" by the driver as a column reference=
rather than making the necessary conversion to the correct datetimeadd "in=
terval" .
I'm attaching the connector file - ODBCPostgresDirect simply because it con=
tains all the flags that I'm setting for SQLCapabilities, ODBC function ove=
rrides etc.
Any input on this would be helpful.
Best,Scott
| | =E3=82=A6=E3=82=A4=E3=83=AB=E3=82=B9 =E3=83=95=E3=83=AA=E3=83=BC=EF=BD=
=A1 www.avg.com |
=20
------=_Part_7808697_1640599030.1565866459616
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydpe323f3c7yahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px=
;"></div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:He=
lvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;">
</div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-fami=
ly:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr=
" data-setdir=3D"false">Hello,</div><div class=3D"ydpe323f3c7yahoo-style-wr=
ap" style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-=
size:13px;" dir=3D"ltr" data-setdir=3D"false"><br></div><div class=3D"ydpe3=
23f3c7yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Ari=
al, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=3D"false"><br></div=
><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:Helvetica =
Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=
=3D"false">I need guidance on sending notification (data) to a soap server =
when transaction occur in PostgreSQL server? How can I accompany this?</div=
><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:Helvetica =
Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=
=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"fo=
nt-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=
=3D"ltr" data-setdir=3D"false">Your help will be highly appreciated.</div><=
div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:Helvetica Ne=
ue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=
=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"fo=
nt-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=
=3D"ltr" data-setdir=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-sty=
le-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;=
font-size:13px;" dir=3D"ltr" data-setdir=3D"false">Thank you.</div><div cla=
ss=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Hel=
vetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=3D"false=
"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family=
:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" =
data-setdir=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" =
style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size=
:13px;" dir=3D"ltr" data-setdir=3D"false">Regards,</div><div class=3D"ydpe3=
23f3c7yahoo-style-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Ari=
al, sans-serif;font-size:13px;" dir=3D"ltr" data-setdir=3D"false">Sahoong</=
div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D"font-family:Helveti=
ca Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir=3D"ltr" data-set=
dir=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" style=3D=
"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" =
dir=3D"ltr" data-setdir=3D"false"><br></div><div class=3D"ydpe323f3c7yahoo-=
style-wrap" style=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-ser=
if;font-size:13px;"><br></div><div class=3D"ydpe323f3c7yahoo-style-wrap" st=
yle=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:1=
3px;">
=20
</div><div class=3D"yahoo_quoted" id=3D"yahoo_quoted_6493489039">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20
<div>
On Wednesday, 14 August 2019, 21:10:32 BST, Scott Goley=
<[email protected]> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id=3D"yiv4619924698"><div><div>Hiroshi, </div><br=
clear=3D"none"><div>I'm happy to say that this has reflected a massive imp=
rovement in performance for this connector / driver. </div><br clear=3D"non=
e"><div>Thank you very much!</div><br clear=3D"none"><div>I can tell there =
are some edge cases which are not working as expected but in general this m=
eets my very high level requirements. </div><div>Let me take a few days to =
isolate these particular issues remaining with reproducible conditions befo=
re sending you further logs. </div><br clear=3D"none"><div>I am most gratef=
ul. </div><br clear=3D"none"><div>Scott</div><br clear=3D"none"><div class=
=3D"yiv4619924698yqt9218796220" id=3D"yiv4619924698yqt24584"><div class=3D"=
yiv4619924698gmail_quote_attribution">On Aug 14 2019, at 10:24 am, Inoue, H=
iroshi <[email protected]> wrote:</div><blockquote><div><br c=
lear=3D"none"><div><div>Oops sorry,</div><div>The error was caused by chang=
es about another problem.</div><br clear=3D"none"><div>Could you please try=
the test drivers on Windows 11.00.0320 at</div></div><div><a title=3D"http=
s://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1@getmai=
lspring.com/0?redirect=3Dhttps%3A%2F%2Flink.getmailspring.com%2Flink%2F59D8=
70E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps=
%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipient%=
3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=3DaC1pbm91ZUBk=
cmVhbS5lbWFpbC5uZS5qcA%3D%3D" href=3D"https://link.getmailspring.com/link/8=
[email protected]/0?redirect=3Dhttps%3A=
%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%=
40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~inou=
e%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5=
qcA%253D%253D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" tar=
get=3D"_blank" rel=3D"nofollow" shape=3D"rect">https://winpg.jp/~inoue/psql=
odbc/index.html</a></div><div><div>?</div><br clear=3D"none"><div>regards,<=
/div><div>Hiroshi Inoue</div></div><br clear=3D"none"><div class=3D"yiv4619=
924698moz-cite-prefix"><div>On 2019/08/14 22:22, Scott Goley wrote:</div></=
div><blockquote><br clear=3D"none"><div>Hiroshi,</div><br clear=3D"none"><d=
iv>I'm afraid this version has broken my ability to make a connection so I =
am unable to verify the rest of the changes. This is after verifying the dr=
iver updated correctly and is showing on the logs as "11.01.0310"</div><br =
clear=3D"none"><div><img alt=3D"" src=3D""></div><br clear=3D"none"><div><i=
mg alt=3D"" src=3D""></div><br clear=3D"none"><div>Best regards,</div><div>=
Scott</div><br clear=3D"none"><div class=3D"yiv4619924698gmail_quote_attrib=
ution">On Aug 14 2019, at 6:49 am, Inoue, Hiroshi <a title=3D"mailto:h-inou=
[email protected]" href=3D"mailto:[email protected]" target=3D"_b=
lank" rel=3D"nofollow" shape=3D"rect" ymailto=3D"mailto:[email protected]=
.ne.jp"><[email protected]></a> wrote:</div><blockquote><div>=
<div>Hi Scott,</div><br clear=3D"none"><div>Could you please try the test d=
rivers on Windows 11.00.0310 at</div><div><a title=3D"https://link.getmails=
pring.com/link/[email protected]/0?red=
irect=3Dhttps%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-97=
24-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwi=
npg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmV=
hbS5lbWFpbC5uZS5qcA%253D%253D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZ=
S5qcA%3D%3D" href=3D"https://link.getmailspring.com/link/827528D4-F338-402D=
[email protected]/0?redirect=3Dhttps%3A%2F%2Flink.getmai=
lspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.c=
om%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%25=
2Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&=
;recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" target=3D"_blank" re=
l=3D"nofollow" shape=3D"rect">https://winpg.jp/~inoue/psqlodbc/index.html</=
a></div><div>?</div><br clear=3D"none"><div>regards,</div><div><div>Hiroshi=
Inoue</div><br clear=3D"none"></div><div class=3D"yiv4619924698moz-cite-pr=
efix"><div>On 2019/08/13 23:27, Scott Goley wrote:</div></div><blockquote><=
br clear=3D"none"><div>Hiroshi - my apologies. I believe that I did not app=
ropriately remove the old version prior to adding this one to my system:</d=
iv><br clear=3D"none"><div>This is the correct result for that version of t=
he driver:</div><br clear=3D"none"><div><img alt=3D"" src=3D""></div><br cl=
ear=3D"none"><div>The other mylog file is over 25mb. As a result, I'm shari=
ng with you via a dropbox link:</div><br clear=3D"none"><div><div><a title=
=3D"https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C=
[email protected]/1?redirect=3Dhttps%3A%2F%2Flink.getmailspring.com%2Flin=
k%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F0%3Fredirect=
%3Dhttps%253A%252F%252Fwww.dropbox.com%252Fs%252Fiwff1b3dl36forr%252Fmylog_=
Microsoft_22916.log%253Fdl%253D0%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5u=
ZS5qcA%253D%253D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" =
href=3D"https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80=
[email protected]/1?redirect=3Dhttps%3A%2F%2Flink.getmailspring.com%2=
Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F0%3Fredi=
rect%3Dhttps%253A%252F%252Fwww.dropbox.com%252Fs%252Fiwff1b3dl36forr%252Fmy=
log_Microsoft_22916.log%253Fdl%253D0%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFp=
bC5uZS5qcA%253D%253D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%=
3D" target=3D"_blank" rel=3D"nofollow" shape=3D"rect">https://www.dropbox.c=
om/s/iwff1b3dl36forr/mylog_Microsoft_22916.log?dl=3D0</a></div></div><div>T=
hank you very much for your quick assistance - I now see the driver attempt=
ing to cast via an interval on date fields.</div><br clear=3D"none"><div>Be=
st,</div><div>Scott</div><br clear=3D"none"><br clear=3D"none"><br clear=3D=
"none"><div class=3D"yiv4619924698gmail_quote_attribution">On Aug 13 2019, =
at 8:46 am, Scott Goley <a title=3D"https://link.getmailspring.com/link/827=
[email protected]/2?redirect=3Dmailto%3As=
cottmgoley%40gmail.com&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3=
D%3D" href=3D"https://link.getmailspring.com/link/827528D4-F338-402D-B793-8=
[email protected]/2?redirect=3Dmailto%3Ascottmgoley%40gmail.com=
&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" target=3D"_blank=
" rel=3D"nofollow" shape=3D"rect"><[email protected]></a> wrote:<=
/div><blockquote><div><div>Hi Hiroshi,</div><br clear=3D"none"><div>Thank y=
ou for your response. I am not currently observing any change between this =
version and the previous version used. Please see the attached.</div><br cl=
ear=3D"none"><div>Best,</div><div>Scott</div><br clear=3D"none"><div class=
=3D"yiv4619924698gmail_quote_attribution">On Aug 12 2019, at 6:44 am, Inoue=
, Hiroshi <a title=3D"https://link.getmailspring.com/link/827528D4-F338-402=
[email protected]/3?redirect=3Dmailto%3Ah-inoue%40dream=
.email.ne.jp&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" href=
=3D"https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C=
[email protected]/3?redirect=3Dmailto%3Ah-inoue%40dream.email.ne.jp&r=
ecipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" target=3D"_blank" rel=
=3D"nofollow" shape=3D"rect"><[email protected]></a> wrote:</=
div><blockquote><div><div>Hi Scott,</div><br clear=3D"none"><div>Could you =
please try the test drivers 11.00.0200 on Windows at</div><div><a title=3D"=
https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1@ge=
tmailspring.com/4?redirect=3Dhttps%3A%2F%2Flink.getmailspring.com%2Flink%2F=
59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dh=
ttps%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipi=
ent%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=3DaC1pbm91=
ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" href=3D"https://link.getmailspring.com/li=
nk/[email protected]/4?redirect=3Dhttp=
s%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2=
DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~=
inoue%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5=
uZS5qcA%253D%253D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D"=
target=3D"_blank" rel=3D"nofollow" shape=3D"rect">https://winpg.jp/~inoue/=
psqlodbc/index.html</a></div><div>?</div><br clear=3D"none"><div>regards,</=
div><div>Hiroshi Inoue</div><br clear=3D"none"><div class=3D"yiv4619924698m=
oz-cite-prefix"><div>On 2019/08/11 7:51, Scott Goley wrote:</div></div><blo=
ckquote><br clear=3D"none"><div>Hiroshi,</div><br clear=3D"none"><div>Thank=
you for your response. I will definitely look into that.</div><br clear=3D=
"none"><div>Is there any resource which specifies what functions and flags =
are supported via the current psqlODBC driver? That would be extremel=
y helpful to me if you were aware of one.</div><br clear=3D"none"><div>Best=
,</div><div>Scott G</div><br clear=3D"none"><br clear=3D"none"><br clear=3D=
"none"><div class=3D"yiv4619924698gmail_quote_attribution">On Aug 9 2019, a=
t 8:56 pm, Inoue, Hiroshi <a title=3D"https://link.getmailspring.com/link/8=
[email protected]/5?redirect=3Dhttps%3A=
%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%=
40getmailspring.com%2F2%3Fredirect%3Dmailto%253Ah-inoue%2540dream.email.ne.=
jp%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=
=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" href=3D"https://link.getmailsp=
ring.com/link/[email protected]/5?redi=
rect=3Dhttps%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-972=
4-BFF629FF2DD7%40getmailspring.com%2F2%3Fredirect%3Dmailto%253Ah-inoue%2540=
dream.email.ne.jp%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253=
D&recipient=3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D" target=3D"_blan=
k" rel=3D"nofollow" shape=3D"rect"><[email protected]></a> wr=
ote:</div><blockquote><div><div>Hi Scott,</div><br clear=3D"none"><div>Unfo=
rtunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is supported now.</div=
><div>Could you please try test drivers which would support them?</div><br =
clear=3D"none"><div>regards,</div><div>Hiroshi Inoue</div><br clear=3D"none=
"><div class=3D"yiv4619924698moz-cite-prefix"><div>On 2019/08/09 0:00, Scot=
t Goley wrote:</div></div><blockquote><br clear=3D"none"><div>Hi,</div><br =
clear=3D"none"><div>Platform / Version info:</div><br clear=3D"none"><div>P=
ostgres 11.4</div><div>psqlODBC_x64 v 11.01.0000</div><br clear=3D"none"><d=
iv>I'm a developer working with PowerQuery / ODBC and I'm running into the =
following issue.</div><br clear=3D"none"><br clear=3D"none"><div>I'm develo=
ping a custom connector which is utilizing this driver. I've attached the l=
ogs as requested when making a bug report. It looks like the SQL_TSI_DAY op=
erator is being "interpreted" by the driver as a column reference rather th=
an making the necessary conversion to the correct datetimeadd "interval" .<=
/div><br clear=3D"none"><div>I'm attaching the connector file - ODBCPostgre=
sDirect simply because it contains all the flags that I'm setting for SQLCa=
pabilities, ODBC function overrides etc.</div><br clear=3D"none"><div>Any i=
nput on this would be helpful.</div><br clear=3D"none"><div>Best,</div><div=
><div><div><div><div>Scott</div></div></div></div></div></blockquote></div>=
</blockquote></blockquote></div></blockquote></div></blockquote></blockquot=
e></div></blockquote></blockquote><div><br clear=3D"none"><div><table style=
=3D"border-top:1px solid #D3D4DE;"><tbody><tr><td style=3D"width:55px;paddi=
ng-top:18px;" rowspan=3D"1" colspan=3D"1"><a href=3D"http://www.avg.com/ema=
il-signature?utm_medium=3Demail&utm_source=3Dlink&utm_campaign=3Dsi=
g-email&utm_content=3Demailclient" target=3D"_blank" rel=3D"nofollow" s=
hape=3D"rect"><img width=3D"46" height=3D"29" style=3D"width:46px;min-heigh=
t:29px;" alt=3D"" src=3D"https://ipmcdn.avast.com/images/icons/icon-envelop=
e-tick-green-avg-v1.png"></a></td><td style=3D"width:470px;padding-top:17px=
;color:#41424e;font-size:13px;font-family:Arial, Helvetica, sans-serif;line=
-height:18px;" rowspan=3D"1" colspan=3D"1">=E3=82=A6=E3=82=A4=E3=83=AB=E3=
=82=B9 =E3=83=95=E3=83=AA=E3=83=BC=EF=BD=A1 <a style=3D"color:#4453ea;" hre=
f=3D"http://www.avg.com/email-signature?utm_medium=3Demail&utm_source=
=3Dlink&utm_campaign=3Dsig-email&utm_content=3Demailclient" target=
=3D"_blank" rel=3D"nofollow" shape=3D"rect">www.avg.com</a> </td></tr></tbo=
dy></table></div></div></div></blockquote></div></div></div></div>
</div>
</div></body></html>
------=_Part_7808697_1640599030.1565866459616--