Re: [sqlite] Views across attached databases

2009-11-30 Thread WClark
Alexey Pechnikov wrote on 30/11/2009 19:58:15: > This feature was disabled becouse can produce inconsistent database schema. > If you want to enable this feature then the patch is simple: > > --- sqlite3-3.6.20.orig/src/attach.c > +++ sqlite3-3.6.20/src/attach.c > @@ -447,10 +447,11 @@ > if(

Re: [sqlite] Views across attached databases

2009-11-30 Thread Alexey Pechnikov
Hello! On Monday 30 November 2009 20:22:43 wcl...@gfs-hofheim.de wrote: > Is there a technical reason why triggers work, but views don't, or is this > just a feature that's not currently supported in views? I know that I can > create a temporary view and this works. Is this something I can

[sqlite] Views across attached databases

2009-11-30 Thread WClark
Hello, Playing around with attached databases in sqlite 3.6.17, I notice that it is possible to create triggers that operate across attached databases, but not views. So something along the lines of: attach database "other.db" as other; create table other.a(a integer); create table b(a