Re: [sqlite] Temporary views across attached databases

[Alexey Pechnikov]

Persistent views across databases supported in old versions of SQLite and
can be allowed in current version by this patch:
http://sqlite.mobigroup.ru/fdiff?v1=b4464923c51570be=6d077a9491474827

Temp view across databases are supported always.

2010/10/1 John Drescher 

> I see that normal views across attached databases do not work but it
> looks like I can create a temporary view across attached databases. Is
> this a supported configuration? I want to make sure before I put this
> in my application.
>
> --
> John M. Drescher
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Temporary views across attached databases

[Alessandro Merolli]

I've being using this feature massively since version 3.6.7. Now I'm  
working (production) with 3.6.22. It works just fine.
I've being testing 3.7.x and it seems OK too.
Best regards.
Alessandro Merolli.

On 01/10/2010, at 14:26, John Drescher wrote:

> I see that normal views across attached databases do not work but it
> looks like I can create a temporary view across attached databases. Is
> this a supported configuration? I want to make sure before I put this
> in my application.
>
> -- 
> John M. Drescher
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Temporary views across attached databases

[John Drescher]

I see that normal views across attached databases do not work but it
looks like I can create a temporary view across attached databases. Is
this a supported configuration? I want to make sure before I put this
in my application.

-- 
John M. Drescher
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users