Thread: pgAdmin 4.20 and 4.21 cannot create foreign key

Using PostgreSQL 9.6 on Linux Centos 7 x64 - yum standard installer.

pgAdmin 4.20 and 4.21 on Windows Server 2019 x64 - .exe standard installer.

I'm trying to create a foreign key using 4.20 and didn't wored: keep always asking to create a covering index.

Tryied in 4.20 and also in 4.21 with same results

Follow the screenshot of the error:

Using PostgreSQL 9.6 on Linux Centos 7 x64 - yum standard installer.

pgAdmin 4.20 and 4.21 on Windows Server 2019 x64 - .exe standard installer.

I'm trying to create a foreign key using 4.20 and didn't wored: keep always asking to create a covering index.

Tryied in 4.20 and also in 4.21 with same results

Follow the screenshot of the error:

Hi Edson

I have tried on PostgreSQL 9.6 and 10, not able to reproduce the issue. Can you please provide the exact steps and the example table?

On Sun, May 3, 2020 at 12:20 AM Edson Richter <edsonrichter@hotmail.com> wrote:

Using PostgreSQL 9.6 on Linux Centos 7 x64 - yum standard installer.

pgAdmin 4.20 and 4.21 on Windows Server 2019 x64 - .exe standard installer.

I'm trying to create a foreign key using 4.20 and didn't wored: keep always asking to create a covering index.

Tryied in 4.20 and also in 4.21 with same results

Follow the screenshot of the error:

--

Thanks & Regards

Akshay Joshi

Sr. Software Architect

EnterpriseDB Software India Private Limited

Mobile: +91 976-788-8246