>> SELECT RAISE(FAIL,'album has songs cannot be deleted')
>> WHERE (SELECT count(album_fk) FROM songs WHERE (album_fk = OLD.id) > 0);
>
> Or simply
>
> where old.id in (select album_fk from songs)
Or most efficiently:
where exists (select 1 from songs where old.id = album_fk)
If the columns ar
On Thu, Jul 29, 2010 at 22:53, Dan Kennedy wrote:
> Looks like it was fixed for 3.6.22:
>
> http://www.sqlite.org/src/ci/c34cf23efb
Thank you. I have changed chromium's copy of sqlite to contain the above
version of the code, so we're closer to upstream now.
__
On 4 Aug 2010, at 12:20am, Paul Sanderson wrote:
> Thanks Oliver that is what I am doing at the moment. I was wondering
> whether there might be a quicker way maybe using temporary tables for
> similar - just exploring ideas
No need. Any efficient way of doing it boils down to either
BEGIN ..
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 07:42 AM, Kirk Clemons wrote:
> I have seen some information on repairing a corrupt database and recovering
> at least some of the data. But I have not had any luck finding out how to do
> it.
You can use .dump in the shell. It does a
Thanks Oliver that is what I am doing at the moment. I was wondering
whether there might be a quicker way maybe using temporary tables for
similar - just exploring ideas
On Tuesday, August 3, 2010, Oliver Peters wrote:
> Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sanderson:
>
> [...]
Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sanderson:
[...]
> I want the process to be as quiick as
> possible (although I know it will take minutes). The process at the
> moment is to drop the indexes, add the new rows and then reindex.
>
> Is this the best/fastest way of achieving t
Hi
I have a table that contains 6 columns of integers, 2 of these columns
are indexed. There are about 10 Million rows of data in the table.
every now and again I need to add more rows, between about a thousand
and a million at a time. I want the process to be as quiick as
possible (although I kno
If the database is corrupted, then this is really bad. If you don't have a
backup of your file, then it's almost not really possible to repair the
database. As far as I know...
You could open the database in an editor and try to pick some data, that
was left in the database.
with best wishes
Art
Yeah perhaps they use SQLite, but you cannot say it for sure. It could
also just ads-links for these poker sites. Who knows..
I checked the attachments on this site you mentioned and they have just
strange tables of data. Don't know, what this has to do with ForeignKeys,
but it's not really relate
Michael,
In this particular instance my questions were posed rhetorically to the OP
after I had given his trigger a little more thought. But I can be lazy, for
sure, so if you don't mind I'll keep your rebuke ready to hand for the next
time it's deserved, which should be soon as it's hot and humid
You could've tested this in the time it took for you to get answer:
File x.sql
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE t (i integer);
INSERT INTO "t" VALUES(1);
CREATE TABLE c(i integer);
CREATE TRIGGER t1 before insert on t begin insert into c values((select
count(*) from t));e
On Tuesday, August 03, 2010 2:15 PM, Simon Slavin wrote:
> You can't attach files to messages to this forum. This is done
> intentionally to stop the posts getting unacceptably long (people
> with problems tend to attach their entire source code).
Cunning! Ok, in that case, if anyone is interes
On 3 Aug 2010, at 1:14pm, Andy Gibbs wrote:
> On Tuesday, August 03, 2010 2:09 PM, Andy Gibbs wrote:
>
>> I've attached a patch to this email as a follow-up to this suggestion.
>
> Sorry, I think I forgot to attach the patch file. Hopefully its attached
> this time!
You can't attach files to
On Tuesday, August 03, 2010 2:09 PM, Andy Gibbs wrote:
I've attached a patch to this email as a follow-up to this suggestion.
Sorry, I think I forgot to attach the patch file. Hopefully its attached
this time!
Andy
___
sqlite-users mailing list
s
On Monday, August 02, 2010 4:25 AM, Nikolaus Rath wrote:
Hi,
Could someone clarify to me how the VACUUM command works if WAL is
enabled?
I would like to compact my database, but I am note sure if I should:
1) Run PRAGMA wal_checkpoint to get all outstanding commits into the
database file an
On 3 Aug 2010, at 12:09pm, Artur Reilin wrote:
> I watching through the wiki to found things that are not correct and such.
> And I noticed, that on
>
> http://www.sqlite.org/cvstrac/wiki?p=SqliteUsers
>
> are many programs not longer available. And also there many links to
> online casinos and
Is a to-be-inserted row supposed to be included among the counted rows in a
BEFORE INSERT trigger? Could you end up with 5 rows? What happens if you
make this an AFTER trigger?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/
Could your trigger be running into the syntax restriction described below?
I'm not sure if the restriction actually applies to your circumstance -- not
sure whether LIMIT and ORDER BY are invalid *anywhere* in a statement in a
trigger that deletes a row, i.e. invalid also in a subquery, as you have
Hello again.
I watching through the wiki to found things that are not correct and such.
And I noticed, that on
http://www.sqlite.org/cvstrac/wiki?p=SqliteUsers
are many programs not longer available. And also there many links to
online casinos and online poker sites. (I think a little bit to muc
On Aug 3, 2010, at 1:38 PM, Belisko Marek wrote:
> Hi,
>
> I will need to clone sqlite3 version 3.2.6.
> Could you please give me some commands how to do it in fossil?
fossil clone http://www.sqlite.org/src sqlite.fossil
fossil open sqlite.fossil
fossil update 1cdfe66714
__
Hi,
I will need to clone sqlite3 version 3.2.6.
Could you please give me some commands how to do it in fossil?
Thanks in advance,
Marek Belisko
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
Dear sqlite developers,
I have noticed that the .dump command quotes the table name on INSERT
commands, but does not quote them on CREATE TABLE commands.
Import operations using the generated SQL into Postgresql fails unless one
manually edits the SQL to quote mixed case or upper case table names
Hello All,
I am new to SQLite and have run into an issue with a malformed database. It
seems the application using the database was shutdown prematurely during an
update operation and the journal file was never deleted. This means that on
startup the application used the wrong journal file and c
23 matches
Mail list logo