Re: relkind check in info.c - Mailing list pgsql-odbc

From Michael Paquier
Subject Re: relkind check in info.c
Date
Msg-id CAB7nPqR0apHpiPAi4J2e3oR2jZ8MREyJAzxdWMjrr4h5PsRp4w@mail.gmail.com
Whole thread Raw
In response to Re: relkind check in info.c  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-odbc
On Wed, May 14, 2014 at 10:46 PM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> We need to decide to what to return in the table_type column for them.
> "FOREIGN TABLE" and "MATERIALIZED VIEW" would be natural choices.
This choice makes sense.

> But it would be good to return the same string that other DBMS's return for
> those things. What does SQL Server's driver return for materialized views?
> I'm not aware of any other DBMS that implements foreign tables per the spec,
> but e.g DB2 has "remote tables" and Oracle has "database links", which are
> similar features. I wonder what table type do they return.
Poking a little bit that, I finished with the patch attached, with
some regression tests attached. It may not be the most beautiful patch
ever, but it is consistent with the current way code is made and it
has the merit to be simple.
Regards,
--
Michael

Attachment

pgsql-odbc by date:

Previous
From: Michael Paquier
Date:
Subject: Commit ad2a4ae causing more damages than fixes in regression tests
Next
From: "Itnal, Prakash (NSN - IN/Bangalore)"
Date:
Subject: Issue with retry_count in socket.c and fix for the same