Re: [sqlite] pragma trigger_info?

2019-06-22 Thread Keith Medcalf
- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Friday, 21 June, 2019

Re: [sqlite] pragma trigger_info?

2019-06-21 Thread Keith Medcalf
sers [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Dominique Devienne >Sent: Friday, 21 June, 2019 04:38 >To: General Discussion of SQLite Database >Subject: [sqlite] pragma trigger_info? > >I trying to reconcile two manually maintained schemas, >o

[sqlite] pragma trigger_info?

2019-06-21 Thread Dominique Devienne
I trying to reconcile two manually maintained schemas, one that's custom and drives the database code at runtime, and another that's the SQLite (DDL) used to instantiate the DBs. Differences exist, because we humans at not that good at rigour. These are fairly large and old schemas, > 200 tables,