Re: [sqlite] Can a foreign key reference a named rowid?

2013-08-11 Thread Baruch Burstein
On Mon, Aug 12, 2013 at 9:24 AM, Dan Kennedy wrote: > On 08/12/2013 01:20 PM, Baruch Burstein wrote: > >> From the documentation for CREATE TABLE: >> >> The parent key of a foreign key constraint is not allowed to use the >> rowid. The parent key must used named columns only. >> >> Does thi

Re: [sqlite] Can a foreign key reference a named rowid?

2013-08-11 Thread Dan Kennedy
On 08/12/2013 01:20 PM, Baruch Burstein wrote: From the documentation for CREATE TABLE: The parent key of a foreign key constraint is not allowed to use the rowid. The parent key must used named columns only. Does this mean it can or can't use a named column that is an alias for the rowid

[sqlite] Can a foreign key reference a named rowid?

2013-08-11 Thread Baruch Burstein
From the documentation for CREATE TABLE: The parent key of a foreign key constraint is not allowed to use the rowid. The parent key must used named columns only. Does this mean it can or can't use a named column that is an alias for the rowid? Is the problem using the rowid, or is the problem