Postgre - SET DEFAULT ON DELETE

jjdev's profile image jjdev posted 12 months ago in Feature discussion Permalink

Hello, thanks for the work.

Using Postgres it is possible to set "SET DEFAULT" to "ON DELETE" in a CONSTRAINT. We can do this via terminal.

It would be great to do this directly in HeidiSQL, when possible, please print this select field :)

Thank you very much.

1 attachment(s):
  • download
ansgar's profile image ansgar posted 12 months ago Permalink

Should not be a problem to add that.

jjdev's profile image jjdev posted 12 months ago Permalink

Thanks a lot, looking forward to the update :)

Code modification/commit 82b1a0f from Ansgar Becker <anse@heidisql.com>, 12 months ago, revision 6665
Support ON UPDATE SET DEFAULT and the same for ON DELETE in PostgreSQL foreign keys. See https://www.heidisql.com/forum.php?t=40413
ansgar's profile image ansgar posted 12 months ago Permalink

Next build offers SET DEFAULT in PostgreSQL mode.

Please login to leave a reply, or register at first.