Re: Attaching database

On 10/15/22 08:56, Igor Korot wrote:
> Hi, Adrian,
> 
> 

> So any and all operations/queries performed before, during or after that 
> will be done on (finance) catalog), because this is the "main" 
> connection, right?
> 

I think you are getting stuck on SQLite terminology:

https://sqlite.org/lang_attach.html

"Transactions involving multiple attached databases are atomic, assuming 
that the main database is not ":memory:" and the journal_mode is not 
WAL. ..."

That is different mechanism all together.

The closest I can come with alternate example is linked tables in Access.

You are working in one client connected to Server A that makes as needed 
connections to Server B to move data back and forth. You are not 
actually connected full time to Server B and your point of reference is 
the connection your client initially made to Server A. So yes because it 
is the "main" connection.

-- 
Adrian Klaver
adrian.klaver@aklaver.com