| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Dave Cramer <davecramer(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-03 01:06:55 |
| Message-ID: | CA+FnnTzQ6Q=CduRuPDUVq_Ck8xfmsgsY7pHU=7QEAH78qz_E=w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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 | |
|---|---|---|---|
| Next Message | Igor Korot | 2026-04-10 18:45:11 | Re: Included fields should not be a part of SQLPrimaryKey() |
| Previous Message | Dave Cramer | 2026-04-01 09:24:17 | Re: Included fields should not be a part of SQLPrimaryKey() |