On Sat, 23 Jul 2016 01:06:23 +
"Smith, Randall" wrote:
> Using "REFERENCES main.Symbols" appears to be a syntax error.
I think you got caught by a special case.
Any kind of DRI would be hard to enforce across database boundaries.
In general, if we have two databases, there's no requirem
> On 23 Jul 2016, at 3:33pm, Dan Kennedy wrote:
>
>> On 2016/07/23 3:30 PM, Simon Slavin wrote:
>>
>>> The other way around should fine, though: use a permanent table to ensure
>>> that only legitimate values appear in a temporary table.
>
> The trouble is that some other process may come alo
into t1 select new.id where new.x > 1;
end;
发件人: Smith, Randall<mailto:rsm...@qti.qualcomm.com>
发送时间: 2016/7/23 9:06
收件人:
sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org>
主题: [sqlite] REFERENCES from TEMPORAR
On 07/23/2016 08:49 PM, R Smith wrote:
On 2016/07/23 3:30 PM, Simon Slavin wrote:
On 23 Jul 2016, at 2:24pm, R Smith wrote:
No, it's not possible to forge permanent references to/from
temporary tables - it defies the objective of being "temporary".
The other way around should fine, though:
On 2016/07/23 3:30 PM, Simon Slavin wrote:
On 23 Jul 2016, at 2:24pm, R Smith wrote:
No, it's not possible to forge permanent references to/from temporary tables - it defies
the objective of being "temporary".
The other way around should fine, though: use a permanent table to ensure that
On 23 Jul 2016, at 2:24pm, R Smith wrote:
> No, it's not possible to forge permanent references to/from temporary tables
> - it defies the objective of being "temporary".
The other way around should fine, though: use a permanent table to ensure that
only legitimate values appear in a temporar
On 2016/07/23 3:06 AM, Smith, Randall wrote:
Hi.
I'm creating a specialized index table to a persistent table that I need to
speed up a one-time operation. This seems like a great application for a
TEMPORARY table in SQLite, so the index will always be reliably cleaned up.
However, I can't
Smith, Randall wrote:
> Is it impossible to have references from temp tables to main tables?
Yes.
> If so, aren't TEMPORARY tables largely useless?
Only if you want to use foreign key constraints.
> Is there another idiom in SQLite for managing tables that are intended
> to have a short life or
Hi.
I'm creating a specialized index table to a persistent table that I need to
speed up a one-time operation. This seems like a great application for a
TEMPORARY table in SQLite, so the index will always be reliably cleaned up.
However, I can't find a way to have REFERENCES to the main table
9 matches
Mail list logo