Postgre - SET DEFAULT ON DELETE

2 posts
jjdev's profile image jjdev posted 2 years 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
10351 posts
ansgar's profile image ansgar posted 2 years ago Permalink

Should not be a problem to add that.

2 posts
jjdev's profile image jjdev posted 2 years ago Permalink

Thanks a lot, looking forward to the update :)

Code modification/commit 82b1a0f from Ansgar Becker <anse@heidisql.com>, 2 years ago, revision 12.4.0.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
10351 posts
ansgar's profile image ansgar posted 2 years ago Permalink

Next build offers SET DEFAULT in PostgreSQL mode.

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