On 2016/07/23 3:30 PM, Simon Slavin wrote:
On 23 Jul 2016, at 2:24pm, R Smith <rsm...@rsweb.co.za> 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 temporary table.
I will in fact be surprised to find out you can even reference another temp
table... perhaps this might be possible since both tables will definitely cease
to exist upon connection closure.
I don't see why this shouldn't be allowed. Assuming that the 'parent'
temporary table has the appropriate index. SQLite doesn't support CREATE
TEMPORARY UNIQUE INDEX but it should understand that an index created on a
temporary table is temporary.
Yes, your reasoning feels right, but I'm coming from the idea that
references (much like Indices and such) are really database objects
themselves, stand-alone units if you will, and they need to have
concrete (non-temporary) linking or at least not mixed
temporary-permanent linking. This is of course not necessarily true, and
possibly quite different in SQLite (where it might be more like a
check-constraint or such), so your point may have merit here and perhaps
allowing referencing FROM a temporary table to a permanent table could
simply be a minor tweak in some line of code inside SQLite.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users