- Postgres Rocks
- :
- About hallkbrdz
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
About hallkbrdz
since
02-12-2019
02-15-2019
hallkbrdz
Adventurer
4
Posts
0
Kudos
0
Solutions
02-15-2019
12:07 PM
I saw that on one conversion that the Migration code noticed that there was both uppercase and lowercase objects and then decided to create two seperate schemas for EDB to hold them.That's not a huge deal for me, but it does require a bit of work to search/replace and get everything into upper as intended. Since Oracle ignores case (unless you put the names in quotes) by default and uses uppercase, it would be nice to have a "ignore schema case" checkbox for use when we know that it isn't important and just force every schema name to upper.
... View more
02-12-2019
12:07 PM
For Oracle materialized views, I'm getting a 0% sucess rate with a result of ""mv_name" is not a materialized view Hint: Use DROP TABLE to remove a table." I'm assuming the tool doesn't know what to do with MV's?
... View more
02-12-2019
11:08 AM
Our source database (vendor code) has several triggers like the following flagged as incompatible with EDB11. How could these be re-written for EDB? CREATE OR REPLACE TRIGGER FCOWNER.FC_DENSITOMETER_BEFORE_INS_UPD BEFORE INSERT OR UPDATE ON fcowner.FC_densitometer FOR EACH ROW WHEN (old.densitometer_index IS NULL OR new.densitometer_number <> old.densitometer_number OR new.densitometer_name <> old.densitometer_name OR (new.densitometer_name IS NOT NULL and old.densitometer_name IS NULL) OR (new.densitometer_name IS NULL AND old.densitometer_name IS NOT NULL) OR new.system_index <> old.system_index) BEGIN :new.last_modified := SYSDATE; END; /
... View more
02-12-2019
11:05 AM
I ran an assesment on one of our databases that makes use of many partitioned tables (just one level deep). I noticed almost all the resulting errors were due to references to these partitiioned tables, such as "relation "table_name" does not exist". This is for tables, indexes, constraints, and views. I don't see that as an issue so long as the resulting DDL is ordered correctly, but I wanted to point this out to improve the tool.
... View more
Latest Tags
No tags yet