On Fri, Mar 26, 2021 at 04:21:13PM -0400, Tim wrote: > Yes anything that involves management at a table level is not practical due to > the size of our database and limited amount of resources (me). I was not aware > of the orafce extension and will keep it in mind. > > Tom, we currently are on EDB AS 12 but its becoming cost inefficient to stay > with EDB due to our scale, since their pricing reflects the size of the > production VMs that are used. So while this migration might be a pain from the > application side.. long run it would be cheaper. > > Jonah, I'm assuming a patch would only apply per Postgres version... so any > future PG version upgrade would require a new patch? While I'm sure technically > its doable.. long run it would be more practical to just move away from these > cursed Oracle dates. Yes, you might be able to compile it yourself for each version, but if it doesn't compile, someone will have to fix it. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
