Data: Create function for dynamic partition creation on INTRADAY.STOCK_PRICES table

spenechap444 / FSA

Python & SQL based repo for performing financial statement analysis

0 stars 0 forks source link

Data: Create function for dynamic partition creation on INTRADAY.STOCK_PRICES table #47

Open spenechap444 opened 9 months ago

spenechap444 commented 9 months ago

Since PL/pgSQL does not support interval partitioning, it must all be done manually through functions and triggers

spenechap444 commented 8 months ago

Function has been created but needs to be tested

spenechap444 commented 7 months ago

Currently facing a bug in this during application testing and still needs to be resolved. It is working from DB anonymous block, so root cause is originating from the application