Re: [sqlite] keys

2018-08-24 Thread Keith Medcalf
On Friday, 24 August, 2018 17:31, w...@us.net wrote: >"The parent key of a foreign key constraint is not allowed to use the >rowid. The parent key must used named columns only." >Why is this? You should think of this as: >"The parent key of a foreign key constraint is not allowed to use the

Re: [sqlite] keys

2018-08-24 Thread Simon Slavin
On 25 Aug 2018, at 12:31am, w...@us.net wrote: > "The parent key of a foreign key constraint is not allowed to use the rowid. > The parent key must used named columns only." > > Why is this? Because it's not named. In theory you could later add a column named 'rowid' to mean a BLOB column.

Re: [sqlite] keys

2018-08-24 Thread ward
got it. Thanks. On 2018-08-24 19:36, J Decker wrote: On Fri, Aug 24, 2018 at 4:31 PM wrote: "The parent key of a foreign key constraint is not allowed to use the rowid. The parent key must used named columns only." Why is this? Which would be more efficient? 1) WITHOUT ROWID and column of

Re: [sqlite] keys

2018-08-24 Thread J Decker
On Fri, Aug 24, 2018 at 4:31 PM wrote: > "The parent key of a foreign key constraint is not allowed to use the > rowid. The parent key must used named columns only." > > Why is this? > Which would be more efficient? > 1) WITHOUT ROWID and column of INTEGER PRIMARY KEY > or > 2) an aliased rowid.

[sqlite] keys

2018-08-24 Thread ward
"The parent key of a foreign key constraint is not allowed to use the rowid. The parent key must used named columns only." Why is this? Which would be more efficient? 1) WITHOUT ROWID and column of INTEGER PRIMARY KEY or 2) an aliased rowid. Background: The data is sparse, incomplete, and