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
>ro
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.
>
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 IN
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.
"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 fuzzy
5 matches
Mail list logo