D. Richard Hipp wrote:
> ... nested transactions (in the form of SAVEPOINTs) will appear in
> the next SQLite release, which we hope to get out by mid-January ...
>
Nice!
I'm hoping you will also provide a SQLITE_OMIT_SAVEPOINT compilation
option, for us embedded guys who are always worrying a
2/09, D. Richard Hipp wrote:
> From: D. Richard Hipp
> Subject: Re: [sqlite] Transaction within script
> To: "General Discussion of SQLite Database"
> Date: Friday, January 2, 2009, 10:29 AM
> On Jan 2, 2009, at 10:56 AM, Igor Tandetnik wrote:
>
> > "D.
"D. Richard Hipp" wrote
in message news:3636c9a5-2c49-42f8-ab43-77168862c...@hwaci.com
> On Jan 2, 2009, at 10:56 AM, Igor Tandetnik wrote:
>> Describing the effects of RELEASE statement as committing a savepoint
>> may be somewhat misleading. How can one commit some changes in the
>> middle of a
On Jan 2, 2009, at 10:56 AM, Igor Tandetnik wrote:
> "D. Richard Hipp" wrote
> in message news:ff9afacd-4cde-4d66-a15f-3b9226df0...@hwaci.com
>> Preliminary documentation can be seen at
>> http://www.sqlite.org/draft/lang_savepoint.html
>
> Describing the effects of RELEASE statement as committi
e data.
Savepoint/Release are means to adjust the place holders for rollback points.
Data is only persisted by a commit.
Ken
--- On Fri, 1/2/09, Igor Tandetnik wrote:
> From: Igor Tandetnik
> Subject: Re: [sqlite] Transaction within script
> To: sqlite-users@sqlite.org
> Date: Frid
ect: Re: [sqlite] Transaction within script
> To: "General Discussion of SQLite Database"
> Date: Friday, January 2, 2009, 9:39 AM
> On Jan 2, 2009, at 10:37 AM, Sherief N. Farouk wrote:
>
> >> SAVEPOINTs is the way PostgreSQL and MySQL do it,
> as well as many
>
"D. Richard Hipp" wrote
in message news:ff9afacd-4cde-4d66-a15f-3b9226df0...@hwaci.com
> Preliminary documentation can be seen at
> http://www.sqlite.org/draft/lang_savepoint.html
Describing the effects of RELEASE statement as committing a savepoint
may be somewhat misleading. How can one commit
On Jan 2, 2009, at 10:37 AM, Sherief N. Farouk wrote:
>> SAVEPOINTs is the way PostgreSQL and MySQL do it, as well as many
>> other SQL database engines. We want to maximize compatibility.
>>
>> We have discussed letting you used named transactions using BEGIN.
>> We
>> might add that in the
> SAVEPOINTs is the way PostgreSQL and MySQL do it, as well as many
> other SQL database engines. We want to maximize compatibility.
>
> We have discussed letting you used named transactions using BEGIN. We
> might add that in the future. But for now, SAVEPOINT seems to be the
> safest way to d
Hello!
В сообщении от Friday 02 January 2009 18:26:56 Sherief N. Farouk написал(а):
> > Preliminary documentation can be seen at
> > http://www.sqlite.org/draft/lang_savepoint.html
>
> Why savepoints? Why not just add support for named transactions? Is there
> some semantic difference I'm missing?
On Jan 2, 2009, at 10:26 AM, Sherief N. Farouk wrote:
>> Preliminary documentation can be seen at
>> http://www.sqlite.org/draft/lang_savepoint.html
>
>
> Why savepoints? Why not just add support for named transactions? Is
> there
> some semantic difference I'm missing?
SAVEPOINTs is the way P
> Preliminary documentation can be seen at
> http://www.sqlite.org/draft/lang_savepoint.html
Why savepoints? Why not just add support for named transactions? Is there
some semantic difference I'm missing?
- Sherief
___
sqlite-users mailing list
sqlit
On Jan 2, 2009, at 7:32 AM, D. Richard Hipp wrote:
>
> On Jan 2, 2009, at 3:50 AM, Marco Bambini wrote:
>
>> Is there any documentation available about savepoints?
>
> Not yet, but there will be soon...
Preliminary documentation can be seen at
http://www.sqlite.org/draft/lang_savepoint.html
Pl
On Jan 2, 2009, at 3:50 AM, Marco Bambini wrote:
> Is there any documentation available about savepoints?
Not yet, but there will be soon, and definitely before the release.
Meanwhile, you can use the SAVEPOINT documentation from PostgreSQL.
SAVEPOINTs in SQLite should work exactly the same
Is there any documentation available about savepoints?
--
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Jan 2, 2009, at 2:19 AM, D. Richard Hipp wrote:
>
> On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote:
>
>> "Webb Sprague"
>> wro
On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote:
> "Webb Sprague"
> wrote in message
> news:b11ea23c0901011622i23f7b583wd05f07104dd06...@mail.gmail.com
>> I have a script containing the following, which works fine except
>> that
>> at the end of the script I get "SQL error near line 5: cannot
"Webb Sprague"
wrote in message
news:b11ea23c0901011622i23f7b583wd05f07104dd06...@mail.gmail.com
> I have a script containing the following, which works fine except that
> at the end of the script I get "SQL error near line 5: cannot commit -
> no transaction is active". The table specified in th
Hi all,
I have a script containing the following, which works fine except that
at the end of the script I get "SQL error near line 5: cannot commit -
no transaction is active". The table specified in the file on line 2
gets created just fine, and populated just fine on line 4. I am using
sqlite
18 matches
Mail list logo
