Re: [sqlite] Database full error?

2011-10-19 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19/10/11 14:03, PA Newsgroups wrote: > Is there anything else that could cause this error? It's on a Windows > computer if that makes any difference. SQLite code has a tendency to report virtually any error involving write calls as the disk being

Re: [sqlite] "database full" errors

2005-06-20 Thread D. Richard Hipp
On Mon, 2005-06-20 at 01:30 -0700, Cory Nelson wrote: > what would cause this error? > > I have a few users reporting it, all with different database file > sizes. is there a limit on row counts in 3.x ? > What OS are you using? The limit on the number of rows is 2^64. I doubt that is what yo

RE: [sqlite] Database Full!

2004-02-17 Thread Fred Williams
lant as to database size as one could quickly paint one's self into a corner in some limited storage and embedded environments. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 7:42 AM To: Greg Obleshchuk Cc: [EMAIL PROTECTED] Subje

Re: [sqlite] Database Full!

2004-02-17 Thread Derrell . Lipman
"Greg Obleshchuk" <[EMAIL PROTECTED]> writes: > Could you open a memory database and then attach the disk based database. > Create the tables in the memory database and copy the rows from the disk > based into memory. Once done detach the database , delete it from disk . If the machine crashes a

Re: [sqlite] Database Full!

2004-02-17 Thread Greg Obleshchuk
February 17, 2004 7:04 PM Subject: Re: [sqlite] Database Full! > Hello, > it seems to me the solution would be: Create a special small file just > to protect some disc space. If you lack on disc space, delete the > protecting file (and hope nobody will steal the disc space inbetween

Re: [sqlite] Database Full!

2004-02-17 Thread Jakub Adamek
Hello, it seems to me the solution would be: Create a special small file just to protect some disc space. If you lack on disc space, delete the protecting file (and hope nobody will steal the disc space inbetween) and delete some records. Than again create the protecting file. Obviously, in a l

Re: [sqlite] Database Full!

2004-02-16 Thread D. Richard Hipp
Benoit Gantaume wrote: Hi, I am trying to handle a problem that occurs when the disk is full: when i try to insert, that return SQLITE_FULL. Ok. There is not problem to get some elements from the database. Then I try to remove some elements... But that returns SQLITE_BUSY! I have tryed to s

Re: [sqlite] Database Full!

2004-02-16 Thread Peter
Benoit Gantaume wrote: Hi, I am trying to handle a problem that occurs when the disk is full: You could pop up a message telling the user to stop surfing for pr0n and delete some of his jpegs. - To unsubscribe, e-mail: [EMAIL P