I have a fair bit of experience with Azure Functions and I've never noticed had issue before, but a timer function I currently use is causing me a bit of a headache. I use the CRON expression: 0 */18 *…
I'm using postgresql 15. i have a table called calls with columns the_time timestamptz, a_number text, a_prefix text, b_number text and b_prefix text. I get bulk data as csv and i insert it directly to the db. the data doesn't…
I am trying to create simple trigger to ensure the "from" or "to" (database usernames) is equal to current_user, then can delete the record. But its always raises an exception. Table Schema: CREATE TABLE policy_test ( id serial not null,…
I'm a bit at a loss currently with pipeline triggers in azure piplines: My pipelines keep triggering for individual CI whenever I commit to my pipeline experimentation branch my_pipeline_experiment_branch. Screenshot from Run-History of Main (Ignore that they're all failing -…
I am creating a "log" system and for this, trigger would be the best way to go I think. The thing is I have a header table (table1) and a line item table (table2). I created 2 new tables (table1log)…
I am writing a PostgreSQL trigger function that will allow me to do an ETL transformation on a data. I have a table with fields (id, price, EFF_FROM, EFF_TO), and if I only insert (id, price, EFF_FROM), EFF_TO needs to…
Would like to know a KQL query to detect changes in ADF triggers. Looking at Log Analytics since we are sending all logs to LA, I see several tables are created and populated, some are not. AzureActivity looked promising but…
I want to make the code that if any of new column's value is null change that one to the value of row before with trigger event CREATE TRIGGER updateField BEFORE INSERT ON message FOR EACH ROW IF (NEW.COLUMN IS…
I'm trying to execute the triggers.sql file. Below is my prisma.schema and triggers.sql file code. I've already migrate the prisma schema and generated it as well. So when I'm running the command npx prisma db execute --file ./prisma/triggers.sql in the…
I need to update the Azure SQL Server table if another SQL Server tables is updated. For example: I have one Azure SQL table dbo.Azuretable and I also have a SQL Server table dbo.sqlservertable. Both these tables are part of…