| From: | Dave Cramer <davecramer(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Included fields should not be a part of SQLPrimaryKey() |
| Date: | 2026-04-11 08:58:49 |
| Message-ID: | CADK3HH+N97ZX98AxW4CbPRCdhB5d3sG1AA4Dnu+BpqC2JrQ1Hg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
I haven't had a chance.
I'll see what I can do this week
Dave Cramer
On Fri, 10 Apr 2026 at 14:45, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> Ping.
>
> Did anybody look into this?
>
> Thank you.
>
>
> On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
>> Dave,
>>
>> On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <davecramer(at)gmail(dot)com> wrote:
>> >
>> > Hi Igor,
>> >
>> > Best to create an issue here
>> https://github.com/postgresql-interfaces/psqlodbc/issues
>>
>> Done - https://github.com/postgresql-interfaces/psqlodbc/issues/170.
>>
>> Thank you.
>>
>> > Dave Cramer
>> >
>> >
>> > On Tue, 31 Mar 2026 at 20:42, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>> >>
>> >> Ping…
>> >>
>> >> On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>> >>>
>> >>> Dave,
>> >>>
>> >>> On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <ikorot01(at)gmail(dot)com>
>> wrote:
>> >>> >
>> >>> > Hi, Dave,
>> >>> >
>> >>> >
>> >>> > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <davecramer(at)gmail(dot)com>
>> wrote:
>> >>> >>
>> >>> >> Hi Igor,
>> >>> >>
>> >>> >> Are you saying that the rest of the columns in the table should
>> not be returned ?
>> >>> >
>> >>> >
>> >>> > If I have PRIMARY KEY with INCLUDED clause, only PK fields should
>> be returned.
>> >>> >
>> >>> >
>> >>> >>
>> >>> >> What version of the ODBC driver are you using?
>> >>> >
>> >>> >
>> >>> > On Windows I’m using the latest driver.
>> >>> > On Linux slightly older.
>> >>>
>> >>> Linux version below:
>> >>>
>> >>> igor(at)WaylandGnome ~/dbhandler/Debug $ emerge -pv psqlodbc
>> >>> * Last emerge --sync was 2y 5d 20h 34m 44s ago.
>> >>>
>> >>> These are the packages that would be merged, in order:
>> >>>
>> >>> Calculating dependencies... done!
>> >>> Dependency resolution took 43.43 s (backtrack: 0/20).
>> >>>
>> >>> [ebuild R ] dev-db/psqlodbc-11.01.0000::gentoo USE="ssl -doc
>> >>> -iodbc -threads" 0 KiB
>> >>>
>> >>> Total: 1 package (1 reinstall), Size of downloads: 0 KiB
>> >>> igor(at)WaylandGnome ~/dbhandler/Debug $
>> >>>
>> >>> Thank you.
>> >>>
>> >>> >
>> >>> > Thank you.
>> >>> >
>> >>> >>
>> >>> >> Dave Cramer
>> >>> >>
>> >>> >>
>> >>> >> On Sat, 28 Mar 2026 at 23:17, Igor Korot <ikorot01(at)gmail(dot)com>
>> wrote:
>> >>> >>>
>> >>> >>> Hi, list,
>> >>> >>>
>> >>> >>> In my experience with PostgreSQL on either Linux or Windows
>> >>> >>> the included fields are returned as part of the call to
>> SQLPrimaryKey.
>> >>> >>>
>> >>> >>> I already sent an E-mail to this list about it but seeing that
>> there is
>> >>> >>> no response, I am trying again.
>> >>> >>>
>> >>> >>> Thank you.
>> >>> >>>
>> >>> >>>
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Igor Korot | 2026-04-10 18:45:11 | Re: Included fields should not be a part of SQLPrimaryKey() |