samodadela

Results 32 comments of samodadela

Thank you very much for your help. I'll wait for the new uom-lib `ComparableUnit` fix and then upgrade Indriya. As for the `RPM` issue I'll use `Hz` or `1/min` for...

Note: I removed the 'Create Materialized views' because the materialized view is created in the same place as are normal views. If i don't comment it out, that code will...

Thanks @MichaelDBA I'll give it a spin. Regarding the 2nd bullet, I was referring to this change: ![image](https://github.com/user-attachments/assets/4ebd315e-679a-4f7a-8f5c-ae8d772fda89) Some of my views have `deptype 'i'` and so are missed by...

I tested the latest version. I had to change the code as in my latest post (add `IN ('n', 'i')`, line 2819). Then the cloning of the schema works using...

@MichaelDBA , I still had to change line 2819... can you take a look and incorporate that change if it makes sense? ``` AND d.deptype in ( 'n', 'i') ```...

@MichaelDBA Thanks for adding the 'i' - works now. I have two minor problems. My migrations contain something like this: ``` create table f_hub ( id varchar(255) not null constraint...

Hi @MichaelDBA , sorry for the bad reproducers. Here's the one for the sequence name: ``` drop schema if exists t_clone_schema cascade; drop schema if exists t_test cascade; create schema...

Here's the reproducer for swapping of index name with constraint name: ``` drop schema if exists t_clone_schema cascade; drop schema if exists t_test cascade; create schema if not exists t_test;...

@MichaelDBA , I pulled the latest code. Now I see some differences that were not there before. Private keys get renamed. For example `flyway_schema_history_pk` will get renamed to `flyway_schema_history_pkey`. Also...

I compared the output you got from pg_table_def() and it's not 100% the same. The syntax is a bit different. There are two items separated with a comma from pg_table_def()...