Questions tagged [recursive-triggers]
3 questions
1
vote
0 answers
MySQL recursive update trigger
I found a number of discussions about this, and it seems mySQL simply doesn't allow the use of recursive triggers.
Other discussions advise against trying to do this, but I'm fairly confident in the design of my trigger, so it doesn't run the risk…
Aaron
- 21
- 4
0
votes
0 answers
Postgres - store collected data from one view into table?
VERSION: Postgres 9.3 / PG-Admin 3
I don't know if there is a way to do this or not - but I have created a view that queries for a real-time data collection of one row. It runs a query and gives a result for that time. Here's my goal:
set that…
Nicoale
- 503
- 2
- 10
- 23
0
votes
1 answer
Why are Recursive Triggers disabled in a 3.8.8.3 database where I did *not* specify the pragma?
According to the SQLite docs, as of version 3.7.0, recursive triggers are supposed to be enabled by default. However, when I open a conncetion to a database using version 3.8.8.3 (specifically with using System.Data.SQLite core from NuGet) and…
Mark A. Donohoe
- 28,442
- 25
- 137
- 286