r journal file for the overall transaction? Just a curious shot in
> the dark.
>
>-Tom
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Monday, January 08, 2007 10:43 AM
> > To: sqlite-users@sqlite.org
&g
mailto:[EMAIL PROTECTED]
> Sent: Monday, January 08, 2007 10:43 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] attach in transaction
>
> [EMAIL PROTECTED] wrote:
> >
> > Can someone tell me why attach cannot be called within transaction?
>
>
At 3:42 PM + 1/8/07, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Can someone tell me why attach cannot be called within transaction?
I do not recall.
Clearly a DETACH will not work inside a transaction if the
table being detached has been accessed or modified within that
[EMAIL PROTECTED] writes:
> The prohibition against running ATTACH within transaction
> first appeared in version 3.0.1. Presumably in version 3.0.0
> you could ATTACH within a transaction.
The prohibition may have appeared in 3.x but attempting an ATTACH within a
transaction doesn't work with
On Mon, Jan 08, 2007 at 03:42:47PM +, [EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] wrote:
> > Can someone tell me why attach cannot be called within transaction?
>
> I do not recall.
>
> Clearly a DETACH will not work inside a transaction if the
> table being detached has been accessed or
[EMAIL PROTECTED] wrote:
>
> Can someone tell me why attach cannot be called within transaction?
I do not recall.
Clearly a DETACH will not work inside a transaction if the
table being detached has been accessed or modified within that
transaction. But ATTACH could work, I would think.
Hi
Can someone tell me why attach cannot be called within transaction? It does
change internal structures, but id doesn't change any tables. And even if it
would have, I think changing tables in the same connection should be allowed.
Wiktor Adamski
7 matches
Mail list logo
