Engine does not support foreign keys - on postgresql

Hi,

I inherited a postgresql database (a mess) that I am looking to improve.

The foreign key tab does not let me input any, claiming the selected engine (server default) does not support foreign keys. As I understand things Postgresql has no alternative engines and indeed does always support foreign keys.

Heidsql version 9.5.0.5196 Session settings has network type as posgresql(experimental)

Is it a lack of some configuration on the db, an example of the experimental nature of Heidi's relationship with Postgresql or maybe something else?

Thanks, T.

p.s. Yes, I agree it's probably me.

HeidiSQL is incomplete here - PostgreSQL may support foreign keys since decades, but HeidiSQL has to know how PostgreSQL wants them to be created. You can create a ticket on GitHub, preferrably with some SQL code for creating a foreign key on PG.

There it is now. Let me know if you need something else.

it's /HeidiSQL/issues/158, but apparently I can't post links yet.