Skip to main content
Database Administrators

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • You are looking for triggers. Commented Jul 22, 2023 at 20:44
  • Thanks! A friend just said the same thing to me. Have to say though, I feel pretty clueless, not sure it's even possible to do them via the ORM. Any examples of triggers that do this sort of thing (whether ORM or plain SQL) would be super helpful. Commented Jul 22, 2023 at 20:53
  • Postgresql's inheritance feature really fits with the issue. Commented Jul 22, 2023 at 21:10
  • @SahapAsci yes, that also look very useful. I think I have a bit of reading to do before I know whether to use inheritance, triggers, or both. Commented Jul 22, 2023 at 22:18
  • Although I did try some stuff with inheritance using this part of the SQLALchemy documentation, but perhaps I didn't try the right example. Everything I did, I still needed to create the parent row first. I suppose this is where triggers come in. Commented Jul 22, 2023 at 22:21