Updating from 2.0.1 to 2.0.3

[aseques]

Issue report

I am updating tds_fdw from 2.0.1 to 2.0.2 (later I have tried to 2.0.3), I followed the steps from the wiki here. The package compiled an installed without issues. But after restarting postgres I wanted to check if the version reports the new version I installed, but it seems it doesn't

                                                List of installed extensions
       Name       | Version |   Schema   |                                    Description                                    
------------------+---------+------------+-----------------------------------------------------------------------------------
 tds_fdw          | 2.0.1   | public     | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)

I found several references about this problem:

• There's an issue #238 indicating that I have to alter extension tds_fdw update;, but I get the same error message ERROR: extension "tds_fdw" has no update path from version "2.0.1" to version "2.0.2", the ticket was reopened by @juliogonzalez but no more changes so far
• Another issue #41 closed by @GeoffMontee stating the update should work without the need to do any alter on the extension

Operating system

NAME="Ubuntu"
VERSION="18.04.6 LTS (Bionic Beaver)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 18.04.6 LTS"
VERSION_ID="18.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=bionic
UBUNTU_CODENAME=bionic

Version of tds_fdw

Reporting 2.0.1, should be 2.0.2

                                                List of installed extensions
       Name       | Version |   Schema   |                                    Description                                    
------------------+---------+------------+-----------------------------------------------------------------------------------
 tds_fdw          | 2.0.1   | public     | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)

Version of PostgreSQL

                                                              version                                                              
-----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 11.15 (Ubuntu 11.15-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit

Version of FreeTDS

$ dpkg -l|grep freetds
ii  freetds-bin                            1.00.82-2ubuntu0.1                              amd64        FreeTDS command-line utilities
ii  freetds-common                         1.00.82-2ubuntu0.1                              all          configuration files for FreeTDS SQL client libraries
ii  freetds-dev                            1.00.82-2ubuntu0.1                              amd64        MS SQL and Sybase client library (static libs and headers)

[aseques]

I tried today the update from 2.0.1 to 2.0.3 and the result has been the same

• Restarting the postgres server (without any visual changes)
• alter extension tds_fdw update;

  ERROR: extension "tds_fdw" has no update path from version "2.0.1" to version "2.0.3" I tried:

[GeoffMontee]

@kav23alex is fixing this in PR #339.

[GeoffMontee]

The corresponding PR has been merged. Thanks, @kav23alex!