John Hardin (Accumula) comments

Results 8 comments of


                                            John Hardin (Accumula)

Deadlock in IndexOptimize returns success

Deadlock detection appears to be working properly in the current (2022-12-03) version. This issue should probably be closed.

Set Deadlock_priority in the index/statistics job

I'm currently doing `SET DEADLOCK_PRIORITY LOW;` before calling the SP, but having that hardcoded in the SP would probably be good. The index maintenance _does_ proceed past the step that...

Request: Ability to re-order objects in model _WITHOUT_ swapping object IDs

Raphael: I went through trying to set up a repro for you and the behavior changed... I defined the collation and added it to one column. Validation failed, and I...

1.2.1: Applying collation to text column is not reflected in SQL and not saved in model

Fix confirmed. The column collation is also not reflected in the HTML Data Dictionary.

1.2.1: Collation created with "Deterministic" checkbox unchecked is saved with "deterministic='true'" in model file

Fix confirmed. Minor cosmetic issue in the model save: ```

1.2.2: Can define FK relationship with ON DELETE SET NULL + FK column Is Required = true (NOT NULL)

I am doing my model design standalone, not attached to a PGSQL instance. The normal default internal model validation did not catch this, and PGSQL didn't complain when creating it...

1.2.2: Can define FK relationship with ON DELETE SET NULL + FK column Is Required = true (NOT NULL)

...oh good god the PGSQL docs say that is _by design_. 🤦 Okay, due to that I would accept a validation _**warning**_ from PGModeler rather than a blocking validation error....

1.2.1: Cannot reliably control PK column order if a FK column is involved

@rkhaotix - this one is kind of annoying because I need to repair several tables every time I update the model, once when it's loaded and then potentially multiple times...