Re: [sqlite] Attached database

6:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Attached database > Is it possible? If I attach database B to database A and database A to > database B. As these statements are committed into A and B, they stay > attached even if I close and reopen. So If anothe

Re: [sqlite] Attached database

w! > > Sylvain > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Wednesday, January 20, 2010 5:17 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Attac

Re: [sqlite] Attached database

inal Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, January 20, 2010 5:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Attached database Tiberio, Sylvain <sylvain.tibe...@eads.com> wrote: >

Re: [sqlite] Attached database

Ok, thanks! Sylvain -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Wednesday, January 20, 2010 5:16 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Attached database > Ok, so cr

Re: [sqlite] Attached database

Tiberio, Sylvain wrote: > About "cross-database foreign key constraints": I agree with you that > attached database can be dettached or changed. So as it is not > possible to > create the foreign key constraint with no attached database (because > parent > table

Re: [sqlite] Attached database

esn't allow to detach > database when foreign key constraints exist on it. > > Sylvain > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov > Sent: Wednesday, January 20, 2010 4:40 PM >

Re: [sqlite] Attached database

o: General Discussion of SQLite Database Subject: Re: [sqlite] Attached database I wouldn't say anything about views - from my POV there's no much harm in supporting cross-database views other than possible user confusion (personally I don't know why it was decided to not support this). But concerning fo

Re: [sqlite] Attached database

I wouldn't say anything about views - from my POV there's no much harm in supporting cross-database views other than possible user confusion (personally I don't know why it was decided to not support this). But concerning foreign keys: how do you think SQLite is supposed to enforce foreign key

[sqlite] Attached database

Hi, I remark some effects if I use a main database with other attached database (ATTACH command): - I cannot create view in main database that select columns from main database and attached database. - There is no foreign key constraints control is the foreign key is on an attached database table.

Re: [sqlite] Attached database

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Filipe Madureira Is there a way to get a list of attached databases? Either by SQL or by function call? == Greetings, Filipe, PRAGMA

[sqlite] Attached database

Hi, Is there a way to get a list of attached databases? Either by SQL or by function call? I want to attach several databases, at several points in time. It can happen that I attempt to attach the same database several times, but I want to prevent different attaches to the same database if it

Re: [sqlite] Attached database atomic-ness

On Feb 21, 2009, at 5:57 AM, Clark Christensen wrote: > > Hello, > > In the docs for ATTACH, I see this information: > > Transactions involving multiple attached databases are atomic, > assuming that the main database is not ":memory:". If the main > database is ":memory:" then > transactions

[sqlite] Attached database atomic-ness

Hello, In the docs for ATTACH, I see this information: Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:". If the main database is ":memory:" then transactions continue to be atomic within each individual database file. But if the