date:20100614

Re: [sqlite] SQLite and Qt

2010-06-14 Thread Sam Carleton

Sylvain,

I have given it a try and it isn't working.  First a quick questions:
Is qsqlite.dll statically linked to the sqlite code or dynamically
linked?  The sqlite3.lib I am trying to link to is the for dynamically
linking, aka requiring the sqlite3.dll.  I am guessing that is the
issue, but since it will take me a while to spin up a statically
linked version of the lib, I thought I might ask before running down
that rat whole;)

Sam

On Wed, Jun 9, 2010 at 4:20 AM, Sylvain Pointeau
 wrote:
>
> build your qt sqlite as a plugin
> then recompile this plugin with the version you want.
>
> http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above
>
> best regards,
> Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] no such table error.

2010-06-14 Thread Tom Lynn

Yes, that's it!  Thanks.


On Mon, Jun 14, 2010 at 3:56 PM, P Kishor  wrote:

> On Mon, Jun 14, 2010 at 5:53 PM, Tom Lynn  wrote:
> > I'm fairly new to sqlite and generally use databases with single tables
> for
> > use with my PERL scripts.  I've encountered a problem where I've tried to
> > insert data into a table named trunks and get the error "No such table:
> > main.atd_data"
> >
> > atd_data is a table that I use in a different script.  The insert
> statement
> > does not reference it whatsoever (shown below).  This error occurs
> whether I
> > execute the statement from my script or from the sqlite3 command shell.
>  I
> > cannot imagine sqlite "remembering" my other table.  Should I suspect
> some
> > kind of file corruption?
> >
> > INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type,
> grp_dir,
> > meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size,
> queued,
> > que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES
> (
> > 001, '6/04/2010', 12, 24, 'tie', 'two', 1300, 0, 1, 0, 0, 0, 0, 0, 0, 0,
> 0,
> > 0);
> >
>
>
> Do you have a TRIGGER that is firing on INSERT INTO trunks, a TRIGGER
> that is trying to fiddle with main.atd_data?
>
>
> --
> Puneet Kishor
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] no such table error.

2010-06-14 Thread P Kishor

On Mon, Jun 14, 2010 at 5:53 PM, Tom Lynn  wrote:
> I'm fairly new to sqlite and generally use databases with single tables for
> use with my PERL scripts.  I've encountered a problem where I've tried to
> insert data into a table named trunks and get the error "No such table:
> main.atd_data"
>
> atd_data is a table that I use in a different script.  The insert statement
> does not reference it whatsoever (shown below).  This error occurs whether I
> execute the statement from my script or from the sqlite3 command shell.  I
> cannot imagine sqlite "remembering" my other table.  Should I suspect some
> kind of file corruption?
>
> INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type, grp_dir,
> meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size, queued,
> que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES (
> 001, '6/04/2010', 12, 24, 'tie', 'two', 1300, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0,
> 0);
>


Do you have a TRIGGER that is firing on INSERT INTO trunks, a TRIGGER
that is trying to fiddle with main.atd_data?


-- 
Puneet Kishor
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] no such table error.

2010-06-14 Thread Tom Lynn

I'm fairly new to sqlite and generally use databases with single tables for
use with my PERL scripts.  I've encountered a problem where I've tried to
insert data into a table named trunks and get the error "No such table:
main.atd_data"

atd_data is a table that I use in a different script.  The insert statement
does not reference it whatsoever (shown below).  This error occurs whether I
execute the statement from my script or from the sqlite3 command shell.  I
cannot imagine sqlite "remembering" my other table.  Should I suspect some
kind of file corruption?

INSERT INTO trunks ( store, trk_date, grp_num, grp_size, grp_type, grp_dir,
meas_hour, usage, seizures, inc_seizures, grp_overflow, queue_size, queued,
que_overflow, que_abandoned, out_service, percent_atb, out_block ) VALUES (
001, '6/04/2010', 12, 24, 'tie', 'two', 1300, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0,
0);

Best regards,
Tom
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] is there a way to extend the field information ?

2010-06-14 Thread Stef Mientki

hello,

I want to extend the field information of a field in a table,
e.g. I want to add a "description" to each field.

The only way that came up in my head was the following:

- create a "special" table, containing the additional field information:

create table _Field_Ex (
  Tabel   Text  Not Null,
  Field   Text  Not Null,
  Description Text )

- for visualizing the total information, the information of the pragma
table info

Pragma table_info (  )

- and the records from the table _Field_Ex

select * from _Field_Ex
  where Tabel = 

- as I can't think of a way to combine these result in SQL
(e.g. the pragma statement doesn't generate a header, the select does)
I combine the results in python.

Now I wonder if this combine can also be done in pure SQL.

And are there other (better) ways to extend the metadata of fields ?

thanks,
Stef Mientki
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

I done a path to make this works, if someone wants! 

Now... 

CREATE TABLE a (a, b); 
INSERT INTO a VALUES (0, 0); 
INSERT INTO a VALUES (0, 1); 
INSERT INTO a VALUES (1, 0); 
INSERT INTO a VALUES (1, 1); 
SELECT * FROM a WHERE a.a = :a AND a.b = ?1; 
SELECT * FROM a WHERE a.a = ?1 AND a.b = :b; 

Have the same behavior! 


|Index: D:/FS_trunk/devpalm_01/poli_sqlite_lib/src/expr.c 
|=== 
|--- D:/FS_trunk/devpalm_01/poli_sqlite_lib/src/expr.c (revisão 323) 
|+++ D:/FS_trunk/devpalm_01/poli_sqlite_lib/src/expr.c (cópia de trabalho) 
|@@ -557,9 +557,21 @@ 
| sqlite3ErrorMsg(pParse, "variable number must be between ?1 and ?%d", 
| db->aLimit[SQLITE_LIMIT_VARIABLE_NUMBER]); 
| } 
|- if( i>pParse->nVar ){ 
|- pParse->nVar = i; 
|+ 
|+ // give to expression parameter with same index, another number to avoid 
conflicts 
|+ // with named parameter (:AAA, $AAA, @AAA) and indexed parameter (?NNN) 
|+ for(i=0; inVarExpr; i++){ 
|+ Expr *pE = pParse->apVarExpr[i]; 
|+ assert( pE!=0 ); 
|+ if( pE->iColumn==pExpr->iColumn ){ 
|+ pE->iColumn = (ynVar)(++pParse->nVar); 
|+ break; 
|+ } 
| } 
|+ 
|+ if( pExpr->iColumn>pParse->nVar ){ 
|+ pParse->nVar = pExpr->iColumn; 
|+ } 
| }else{ 
| /* Wildcards like ":aaa", "$aaa" or "@aaa". Reuse the same variable 
| ** number as the prior appearance of the same name, or if the name 



-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

I read that but that say "To avoid confusion, it is best to avoid mixing...", 
but you need never mix them, if you want have none collateral effects !!! 


- Mensagem original - 
De: "Jay A. Kreibich"  
Para: "General Discussion of SQLite Database"  
Enviadas: Segunda-feira, 14 de Junho de 2010 15:41:01 
Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) 

On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on 
the wall: 
> I know what you booth are are saying. But if this is a limitation of sqlite, 
> this need be documented, and doesn't have any comment of this behavior. 

http://sqlite.org/lang_expr.html#varparam 

"Named parameters are also numbered. The number assigned is the 
next unused number. To avoid confusion, it is best to avoid mixing 
named and numbered parameters." 

The docs are pretty clear about what happened, and that you shouldn't 
do that, and that if you do it anyways you will likely be confused. 

-j 

-- 
Jay A. Kreibich < J A Y @ K R E I B I.C H > 

"Intelligence is like underwear: it is important that you have it, 
but showing it to the wrong people has the tendency to make them 
feel uncomfortable." -- Angela Johnson 
___ 
sqlite-users mailing list 
sqlite-users@sqlite.org 
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich

On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on 
the wall:
> I know what you booth are are saying. But if this is a limitation of sqlite, 
> this need be documented, and doesn't have any comment of this behavior. 

  http://sqlite.org/lang_expr.html#varparam

 "Named parameters are also numbered. The number assigned is the
  next unused number. To avoid confusion, it is best to avoid mixing
  named and numbered parameters."

  The docs are pretty clear about what happened, and that you shouldn't
  do that, and that if you do it anyways you will likely be confused.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

I know what you booth are are saying. But if this is a limitation of sqlite, 
this need be documented, and doesn't have any comment of this behavior. 
And the name of parameter ':a' are changed, we can't set his value, 
only using the index or your new name '?1' !!! 

- Mensagem original - 
De: "David Bicking"  
Para: "General Discussion of SQLite Database"  
Enviadas: Segunda-feira, 14 de Junho de 2010 13:06:02 
Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) 

I think in your first example, the :a comes first, so it is assigned the first 
index value. You then use ?1, which also uses the first parameter index. 

In the second, you use ?1 first, then :b, which sees the first index has been 
used and thus assigns it to the second index. 

As I believe Jay said, you should not mix named and numbered parameter syntax. 

David 

--- On Mon, 6/14/10, Israel Lins Albuquerque  
wrote: 

> From: Israel Lins Albuquerque  
> Subject: Re: [sqlite] Parametrized Queries issue (Possible bug) 
> To: "General Discussion of SQLite Database"  
> Date: Monday, June 14, 2010, 10:55 AM 
> Once more detail... 
> 
> Doing this... 
> 
> SELECT * 
> FROM a 
> WHERE a.a = :a 
> AND a.b = ?1; 
> 
> and this... 
> 
> SELECT * 
> FROM a 
> WHERE a.a = ?1 
> AND a.b = :b; 
> 
> Will have different behavior! 
> 
> 
> 
> - Mensagem original - 
> De: "Israel Lins Albuquerque"  
> 
> Para: "sqlite-users"  
> 
> Enviadas: Segunda-feira, 14 de Junho de 2010 11:51:07 
> Assunto: [sqlite] Parametrized Queries issue (Possible bug) 
> 
> 
> Using the example above I see one not documented issue. 
> When I use parameters ?NNN and : or @ or $ , 
> in same query as above some of then will be omitted. I 
> don't know if this is the expected behavior or not. 
> 
> CREATE TABLE a (a, b); 
> CREATE TABLE b (a, b); 
> 
> INSERT INTO a VALUES (0, 1); 
> INSERT INTO a VALUES (1, 0); 
> INSERT INTO a VALUES (1, 1); 
> INSERT INTO b VALUES (0, 1); 
> INSERT INTO b VALUES (1, 0); 
> INSERT INTO b VALUES (1, 1); 
> 
> SELECT * 
> FROM a 
> JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
> WHERE a.a = ?1; 
> 
> In this query as 2 parameters but will be see like only 
> one! 
> 
> -- 
> 
> Atenciosamente/Regards, 
> 
> Israel Lins Albuquerque 
> Desenvolvimento/Development 
> Polibrás Brasil Software Ltda. 
> 
> 
> ___ 
> sqlite-users mailing list 
> sqlite-users@sqlite.org 
> 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 
> 
> 
> 
> -- 
> 
> Atenciosamente/Regards, 
> 
> Israel Lins Albuquerque 
> Desenvolvimento/Development 
> Polibrás Brasil Software Ltda. 
> 
> 
> ___ 
> sqlite-users mailing list 
> sqlite-users@sqlite.org 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 
> 
___ 
sqlite-users mailing list 
sqlite-users@sqlite.org 
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-14 Thread Alexey Pechnikov

And this is needed as replacement of the "distinct on" clause. I don't
know other way to translate many queries from PostgreSQL to SQLite.

2010/6/11 Igor Tandetnik :
> SQLite allows "naked" non-grouped columns as an extension (which is 
> occasionally useful).


-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread David Bicking

I think in your first example, the :a comes first, so it is assigned the first 
index value. You then use ?1, which also uses the first parameter index.

In the second, you use ?1 first, then :b, which sees the first index has been 
used and thus assigns it to the second index.

As I believe Jay said, you should not mix named and numbered parameter syntax.

David

--- On Mon, 6/14/10, Israel Lins Albuquerque  
wrote:

> From: Israel Lins Albuquerque 
> Subject: Re: [sqlite] Parametrized Queries issue (Possible bug)
> To: "General Discussion of SQLite Database" 
> Date: Monday, June 14, 2010, 10:55 AM
> Once more detail... 
> 
> Doing this... 
> 
> SELECT * 
> FROM a 
> WHERE a.a = :a 
> AND a.b = ?1; 
> 
> and this... 
> 
> SELECT * 
> FROM a 
> WHERE a.a = ?1 
> AND a.b = :b; 
> 
> Will have different behavior! 
> 
> 
> 
> - Mensagem original - 
> De: "Israel Lins Albuquerque" 
> 
> Para: "sqlite-users" 
> 
> Enviadas: Segunda-feira, 14 de Junho de 2010 11:51:07 
> Assunto: [sqlite] Parametrized Queries issue (Possible bug)
> 
> 
> Using the example above I see one not documented issue.
> When I use parameters ?NNN and : or @ or $ , 
> in same query as above some of then will be omitted. I
> don't know if this is the expected behavior or not. 
> 
> CREATE TABLE a (a, b); 
> CREATE TABLE b (a, b); 
> 
> INSERT INTO a VALUES (0, 1); 
> INSERT INTO a VALUES (1, 0); 
> INSERT INTO a VALUES (1, 1); 
> INSERT INTO b VALUES (0, 1); 
> INSERT INTO b VALUES (1, 0); 
> INSERT INTO b VALUES (1, 1); 
> 
> SELECT * 
> FROM a 
> JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
> WHERE a.a = ?1; 
> 
> In this query as 2 parameters but will be see like only
> one! 
> 
> -- 
> 
> Atenciosamente/Regards, 
> 
> Israel Lins Albuquerque 
> Desenvolvimento/Development 
> Polibrás Brasil Software Ltda. 
> 
> 
> ___ 
> sqlite-users mailing list 
> sqlite-users@sqlite.org
> 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 
> 
> -- 
> 
> Atenciosamente/Regards, 
> 
> Israel Lins Albuquerque 
> Desenvolvimento/Development 
> Polibrás Brasil Software Ltda. 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] output problem

2010-06-14 Thread Simon Slavin

On 14 Jun 2010, at 1:53pm, Mark wrote:

> thanks, yeah sorry, what I meant to ask was, because the .read command is 
> going away to read another file, 
> away from this one, if you know what I mean, does it
> actually know to wait for that to finish, or once it's started
> executing the .read, does it immediately move on to the
> dump?

The command-line tool does not call another utility to process the '.read' 
command, it has to do all the work itself.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Richard Hipp

On Mon, Jun 14, 2010 at 10:40 AM, Simon Slavin  wrote:

>
> On 14 Jun 2010, at 3:06pm, Black, Michael (IS) wrote:
>
> > And if Peter isn't the problem you can do a binary search.
>
> It is Peter.  I have the same entry in the headers on the bounce messages I
> receive: peter.spi...@[omitted for privacy].
>

Thanks for spotting this.  Peter has been unsubscribed.  Hopefully that will
clear the mail loop problem.



>
> Simon.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

2010-06-14 Thread Mark

thanks, yeah sorry, what I meant to ask was, because the .read command is going 
away to read another file, 
away from this one, if you know what I mean, does it
actually know to wait for that to finish, or once it's started
executing the .read, does it immediately move on to the
dump?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich

On Mon, Jun 14, 2010 at 12:07:08PM -0300, Israel Lins Albuquerque scratched on 
the wall:
> Yes. I know that, but the names of parameters are different, 
> and I debug this and the parameter named as ':a' will be overwrited by '?1', 
> and if I use sqlite3_bind_parameter_index(stmt, ":a") will fail, returning 0. 
> But actually they are not the same. 

  Yes they are.  Names are just short-cuts to indexes.  Named
  parameters use "the first unused index."  You then set an explicit
  index that is already in use.  Each index can only have one name,
  so it is over-written with the last-used representation.



  To avoid such problems, it is strongly advised you do not mix
  parameter types.  Either use bare parameters, explicit indexes,
  or names-- but pick one and stick with it.

   -j


-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Pavel Ivanov

>> Do you mean you're making changes as you call SQLite to _step() through the
>> results of the SELECT ?  Or do you read all the results of the SELECT into
>> memory, then make changes to the database ?
>
> The former.

Oh, I completely forgot that people can do that. So, Robert, you case
is exactly the case I was talking about. As Simon said your SELECT
opens read-only transaction and then as you issue your first UPDATE
this transaction have to be converted to writing one. This is a call
for problems. So you better to issue "BEGIN IMMEDIATE" before you
execute your SELECT statement.

BTW, I hope you don't change the table you selected in this scenario?

Pavel

On Mon, Jun 14, 2010 at 10:43 AM, Robert Latest
 wrote:
> On Mon, Jun 14, 2010 at 4:36 PM, Simon Slavin  wrote:
>
>> Do you mean you're making changes as you call SQLite to _step() through the
>> results of the SELECT ?  Or do you read all the results of the SELECT into
>> memory, then make changes to the database ?
>
> The former.
> robert
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

Yes. I know that, but the names of parameters are different, 
and I debug this and the parameter named as ':a' will be overwrited by '?1', 
and if I use sqlite3_bind_parameter_index(stmt, ":a") will fail, returning 0. 
But actually they are not the same. 


- Mensagem original - 
De: "Jay A. Kreibich"  
Para: "General Discussion of SQLite Database"  
Enviadas: Segunda-feira, 14 de Junho de 2010 12:00:32 
Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) 

On Mon, Jun 14, 2010 at 11:51:07AM -0300, Israel Lins Albuquerque scratched on 
the wall: 
> Using the example above I see one not documented issue. When I use parameters 
> ?NNN and : or @ or $ , 
> in same query as above some of then will be omitted. I don't know if this is 
> the expected behavior or not. 
> 
> CREATE TABLE a (a, b); 
> CREATE TABLE b (a, b); 
> 
> INSERT INTO a VALUES (0, 1); 
> INSERT INTO a VALUES (1, 0); 
> INSERT INTO a VALUES (1, 1); 
> INSERT INTO b VALUES (0, 1); 
> INSERT INTO b VALUES (1, 0); 
> INSERT INTO b VALUES (1, 1); 
> 
> SELECT * 
> FROM a 
> JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
> WHERE a.a = ?1; 
> 
> In this query as 2 parameters but will be see like only one! 


It is expected. 

Nearly all SQL interfaces work this way. 

It is a feature. The same value will be used in both locations in 
the query. 

-j 

-- 
Jay A. Kreibich < J A Y @ K R E I B I.C H > 

"Intelligence is like underwear: it is important that you have it, 
but showing it to the wrong people has the tendency to make them 
feel uncomfortable." -- Angela Johnson 
___ 
sqlite-users mailing list 
sqlite-users@sqlite.org 
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Jay A. Kreibich

On Mon, Jun 14, 2010 at 11:51:07AM -0300, Israel Lins Albuquerque scratched on 
the wall:
> Using the example above I see one not documented issue. When I use parameters 
> ?NNN and : or @ or $ , 
> in same query as above some of then will be omitted. I don't know if this is 
> the expected behavior or not. 
> 
> CREATE TABLE a (a, b); 
> CREATE TABLE b (a, b); 
> 
> INSERT INTO a VALUES (0, 1); 
> INSERT INTO a VALUES (1, 0); 
> INSERT INTO a VALUES (1, 1); 
> INSERT INTO b VALUES (0, 1); 
> INSERT INTO b VALUES (1, 0); 
> INSERT INTO b VALUES (1, 1); 
> 
> SELECT * 
> FROM a 
> JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
> WHERE a.a = ?1; 
> 
> In this query as 2 parameters but will be see like only one! 


   It is expected.

   Nearly all SQL interfaces work this way.

   It is a feature.  The same value will be used in both locations in
   the query.

-j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Simon Slavin

On 14 Jun 2010, at 3:43pm, Robert Latest wrote:

> On Mon, Jun 14, 2010 at 4:36 PM, Simon Slavin  wrote:
> 
>> Do you mean you're making changes as you call SQLite to _step() through the
>> results of the SELECT ?  Or do you read all the results of the SELECT into
>> memory, then make changes to the database ?
> 
> The former.

Right.  Well, the SELECT command is creating its own TRANSACTION, and that 
TRANSACTION lasts until you have finished stepping through its response.  So 
that needs to be considered as a reason for your LOCKED, as if you have two 
simultaneous database users.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

Once more detail... 

Doing this... 

SELECT * 
FROM a 
WHERE a.a = :a 
AND a.b = ?1; 

and this... 

SELECT * 
FROM a 
WHERE a.a = ?1 
AND a.b = :b; 

Will have different behavior! 



- Mensagem original - 
De: "Israel Lins Albuquerque"  
Para: "sqlite-users"  
Enviadas: Segunda-feira, 14 de Junho de 2010 11:51:07 
Assunto: [sqlite] Parametrized Queries issue (Possible bug) 

Using the example above I see one not documented issue. When I use parameters 
?NNN and : or @ or $ , 
in same query as above some of then will be omitted. I don't know if this is 
the expected behavior or not. 

CREATE TABLE a (a, b); 
CREATE TABLE b (a, b); 

INSERT INTO a VALUES (0, 1); 
INSERT INTO a VALUES (1, 0); 
INSERT INTO a VALUES (1, 1); 
INSERT INTO b VALUES (0, 1); 
INSERT INTO b VALUES (1, 0); 
INSERT INTO b VALUES (1, 1); 

SELECT * 
FROM a 
JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
WHERE a.a = ?1; 

In this query as 2 parameters but will be see like only one! 

-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___ 
sqlite-users mailing list 
sqlite-users@sqlite.org 
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque

Using the example above I see one not documented issue. When I use parameters 
?NNN and : or @ or $ , 
in same query as above some of then will be omitted. I don't know if this is 
the expected behavior or not. 

CREATE TABLE a (a, b); 
CREATE TABLE b (a, b); 

INSERT INTO a VALUES (0, 1); 
INSERT INTO a VALUES (1, 0); 
INSERT INTO a VALUES (1, 1); 
INSERT INTO b VALUES (0, 1); 
INSERT INTO b VALUES (1, 0); 
INSERT INTO b VALUES (1, 1); 

SELECT * 
FROM a 
JOIN b ON (a.a = b.a AND a.b = :b AND a.b = b.b) 
WHERE a.a = ?1; 

In this query as 2 parameters but will be see like only one! 

-- 

Atenciosamente/Regards, 

Israel Lins Albuquerque 
Desenvolvimento/Development 
Polibrás Brasil Software Ltda. 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Jay A. Kreibich

On Mon, Jun 14, 2010 at 09:42:09AM -0400, Pavel Ivanov scratched on the wall:
> > This is interesting. I often have situations where I SELECT something
> > and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
> > iterate through the results.
> >
> > Is this what you mean by your statement? If yes, how should such
> > situations be avoided, and why?

> If you don't issue BEGIN then your
> SELECT and UPDATE are executed in different transactions

  I'm not sure that's true...  A database connection typically has only
  one transaction state.  Locks, etc., are owned by the connection, not
  by a statement.

  The SELECT is going to create a read-only autocommit transaction.  If
  a write statements are intermixed, they will need to establish an
  autocommit write transaction.  I'm fairly sure this simply upgrades
  the existing autocommit transaction, rather than creating a different
  logical transaction.  Once the write statement finishes, I would
  assume the still-active autocommit transaction remains at the
  elevated level, since there is no way to "degrade" a transaction
  without committing it.  The initial autocommit transaction won't
  actually commit and close until the all active statements are fully
  reset or finalized.

  In short, it will be the same as putting a BEGIN/END around the
  where the SELECT is processed in the code.


  I think.  I have to admit that this gets into some gray areas on
  autocommit transactions that I don't know all that well.  
  
  I do know is that intermixing modifications while walking through
  a SELECT has always worked exactly the way I expected.

   -j



-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Robert Latest

On Mon, Jun 14, 2010 at 4:36 PM, Simon Slavin  wrote:

> Do you mean you're making changes as you call SQLite to _step() through the
> results of the SELECT ?  Or do you read all the results of the SELECT into
> memory, then make changes to the database ?

The former.
robert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Simon Slavin


On 14 Jun 2010, at 3:06pm, Black, Michael (IS) wrote:

> And if Peter isn't the problem you can do a binary search.

It is Peter.  I have the same entry in the headers on the bounce messages I 
receive: peter.spi...@[omitted for privacy].

Simon.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Simon Slavin

On 14 Jun 2010, at 1:44pm, Robert Latest wrote:

> This is interesting. I often have situations where I SELECT something
> and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
> iterate through the results.

Do you mean you're making changes as you call SQLite to _step() through the 
results of the SELECT ?  Or do you read all the results of the SELECT into 
memory, then make changes to the database ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Robert Latest

Thanks, your and Pavel's clarifications have been very helpful.
robert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Jay A. Kreibich

On Mon, Jun 14, 2010 at 02:44:02PM +0200, Robert Latest scratched on the wall:
> On Fri, Jun 11, 2010 at 5:26 PM, Pavel Ivanov  wrote:
> 
> > 1. Ensure that you have no transactions started with SELECT and
> > continued with INSERT/DELETE/UPDATE
> 
> This is interesting. I often have situations where I SELECT something
> and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
> iterate through the results.
> 
> Is this what you mean by your statement? If yes, how should such
> situations be avoided, and why?

  Not so much... the issue is that if you start a transaction, do a
  bunch of selects (e.g. read-only) and then modify the database in
  some way, the transaction needs to acquire the write lock in order to
  proceed.  If there are going to be locking issues, this is where they
  will manifest themselves.  This is also the specific situation that
  can lead to a deadlock, so you're only real choice is to rollback the
  transaction.

  On the practical side, this shouldn't be a big deal... The transaction
  should be read-only at that point, so rolling back the transaction
  doesn't actually change the database or undo any of the "work" done
  by the application.  As an extension of that, the program logic
  should be fairly easy to deal with, since no actual changes have
  been made.

  But that assumes the program flow and control is designed to handle
  that.  If the application design expects to do a "unit of work" and
  that unit just happens to have a bunch of read stuff before it gets
  to the write stuff, you're still breaking that unit of work in the
  middle.  Depending on the code design, that can be a tricky error
  condition to handle.

  Possible solutions include opening the transaction with a pre-acquired
  reserved lock (or exclusive lock).  That avoids the mid-way
  transition.  There can still be issues, but they'll happen at the
  very beginning of the transaction, when it is usually easier to
  restart.

  Another possibility is to break the work up into two steps-- do all
  the read work, then open the transaction and do all the write work. 
  That can be risky if the two parts are related, however.  Read-only
  transactions are still useful, in that they keep the database from
  changing while you're looking up keys or something critical.

  But your general approach of looping over a select and doing other
  things is completely valid.  You just need to be ready to handle a
  busy condition at the first modification.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Adam DeVita

Is it possible for the list admin to seed a message to the list that, if
auto-replied, would automatically remove one from the list?

This thread, although off the sqlite topic, is still interesting.

regards,
Adam

On Mon, Jun 14, 2010 at 10:06 AM, Black, Michael (IS) <
michael.bla...@ngc.com> wrote:

> And if Peter isn't the problem you can do a binary search.
>
> With 2500 members just keep splitting the list in half and set a test email
> to each half.
> Then do it again for the half that shows the loop.
>
> 2500->1250->625->318->159->80->40->20->10->5->3->2->1
>
> 26 emails will ID the culprit (two at each level -- one should show the
> loop and one should not).
>
> Just put a different subject in each email so you know what you're looking
> at.
>
> Or...2500 emails to each person on the list..one of which should show up on
> this list.
>
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 8:30 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> On Mon, Jun 14, 2010 at 9:09 AM, Black, Michael (IS) <
> michael.bla...@ngc.com
> > wrote:
>
> > The problem is that somebody has a .forward or such which loops back to
> the
> > list.  It's probably in the alias expansion of sqlite-users which expands
> to
> > a listfor which a member then expands back to sqlite-users.
> >
> > The mail logs may show whether it happens locally or if its a remote
> user.
> >  If it's a remote user you should see a log entry complaining about too
> many
> > loops and it may ID the user name involved.
> >
> >
> > I'd check sqlite-users for another sqlite-users@ entry...
> >
>
> There is no "sqlite-users" entry in the (2500+) membership list for
> sqlite-users.  Nor am I able to find any clues in the header of the bounce
> reply.  Another ideas?
>
>
> >
> > Michael D. Black
> > Senior Scientist
> > Northrop Grumman Mission Systems
> >
> >
> > 
> >
> > From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> > Sent: Mon 6/14/2010 7:46 AM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] Mail loop?
> >
> >
> >
> > It is not just you.  But I have no idea what the problem is or how to fix
> > it.
> >
> > On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) <
> > michael.bla...@ngc.com
> > > wrote:
> >
> > > I've been seing this the last 2-3 weeks whenever I email the list...is
> it
> > > just me???
> > >
> > >
> > > This is the mail system at host sqlite.org.
> > >
> > > I'm sorry to have to inform you that your message could not
> > > be delivered to one or more recipients. It's attached below.
> > >
> > > For further assistance, please send mail to postmaster.
> > >
> > > If you do so, please include this problem report. You can
> > > delete your own text from the attached returned message.
> > >
> > >   The mail system
> > >
> > > : mail forwarding loop for
> > > sqlite-users@sqlite.org
> > >
> > >
> > >
> > > Michael D. Black
> > > Senior Scientist
> > > Northrop Grumman Mission Systems
> > >
> > >
> > >
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > >
> >
> >
> > --
> > -
> > D. Richard Hipp
> > d...@sqlite.org
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


-- 
VerifEye Technologies Inc.
905-948-0015x245
7100 Warden Ave, Unit 3
Markham ON, L3R 8B5
Canada
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Black, Michael (IS)

And if Peter isn't the problem you can do a binary search.
 
With 2500 members just keep splitting the list in half and set a test email to 
each half.
Then do it again for the half that shows the loop.
 
2500->1250->625->318->159->80->40->20->10->5->3->2->1
 
26 emails will ID the culprit (two at each level -- one should show the loop 
and one should not).
 
Just put a different subject in each email so you know what you're looking at.
 
Or...2500 emails to each person on the list..one of which should show up on 
this list.
 
 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 



From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
Sent: Mon 6/14/2010 8:30 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Mail loop?



On Mon, Jun 14, 2010 at 9:09 AM, Black, Michael (IS)  wrote:

> The problem is that somebody has a .forward or such which loops back to the
> list.  It's probably in the alias expansion of sqlite-users which expands to
> a listfor which a member then expands back to sqlite-users.
>
> The mail logs may show whether it happens locally or if its a remote user.
>  If it's a remote user you should see a log entry complaining about too many
> loops and it may ID the user name involved.
>
>
> I'd check sqlite-users for another sqlite-users@ entry...
>

There is no "sqlite-users" entry in the (2500+) membership list for
sqlite-users.  Nor am I able to find any clues in the header of the bounce
reply.  Another ideas?


>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 7:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> It is not just you.  But I have no idea what the problem is or how to fix
> it.
>
> On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) <
> michael.bla...@ngc.com
> > wrote:
>
> > I've been seing this the last 2-3 weeks whenever I email the list...is it
> > just me???
> >
> >
> > This is the mail system at host sqlite.org.
> >
> > I'm sorry to have to inform you that your message could not
> > be delivered to one or more recipients. It's attached below.
> >
> > For further assistance, please send mail to postmaster.
> >
> > If you do so, please include this problem report. You can
> > delete your own text from the attached returned message.
> >
> >   The mail system
> >
> > : mail forwarding loop for
> > sqlite-users@sqlite.org
> >
> >
> >
> > Michael D. Black
> > Senior Scientist
> > Northrop Grumman Mission Systems
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


--
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread P Kishor

Funny that... I got the "mail loop error" reply to my email below


> This is the mail system at host sqlite.org.
>
> I'm sorry to have to inform you that your message could not
> be delivered to one or more recipients. It's attached below.
>
> For further assistance, please send mail to postmaster.
>
> If you do so, please include this problem report. You can
> delete your own text from the attached returned message.
>
>   The mail system
>
> : mail forwarding loop for sqlite-users@sqlite.org


but it still seems to have gotten through as Michael replied.

On Mon, Jun 14, 2010 at 8:42 AM, Black, Michael (IS)
 wrote:
>
> It's been that way since email existed.  Mail loops used to cause complete 
> havoc with the internet and mail servers.  Especially local loops.  People 
> used to just kill their email servers to stop it.  And out-of-office replies 
> caused havoc with email lists when they first came out.
>
..



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Black, Michael (IS)

It's been that way since email existed.  Mail loops used to cause complete 
havoc with the internet and mail servers.  Especially local loops.  People used 
to just kill their email servers to stop it.  And out-of-office replies caused 
havoc with email lists when they first came out.

Mail loop detection was added to many systems around 5 years ago or so to stop 
the problem.

Unless somebody has a brilliant idea to fix email world-wide we have to suffer 
a bit.

All it takes is this:

us...@somwhere -> maill...@somewhereelse -> us...@somewhereelse (has a .forward 
to maill...@somewhereelse ). And voila! A mail loop.

People who don't have considerable long-term email server experience are 
gleefully unaware of the history behind this.  I was a network admin back in 
the 80's and saw this problem lots of times.

Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems

From: sqlite-users-boun...@sqlite.org on behalf of P Kishor
Sent: Mon 6/14/2010 8:12 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Mail loop?

On Mon, Jun 14, 2010 at 8:09 AM, Black, Michael (IS)
 wrote:
> The problem is that somebody has a .forward or such which loops back to the 
> list.  It's probably in the alias expansion of sqlite-users which expands to 
> a listfor which a member then expands back to sqlite-users.
>
> The mail logs may show whether it happens locally or if its a remote user.  
> If it's a remote user you should see a log entry complaining about too many 
> loops and it may ID the user name involved.
>

Happened to me a few days ago. It would be a very bad design on the
part of the mail list manager software if one errant user could cause
bad behavior to percolate to everyone on the list.

>
> I'd check sqlite-users for another sqlite-users@ entry...
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 7:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> It is not just you.  But I have no idea what the problem is or how to fix
> it.
>
> On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) > wrote:
>
>> I've been seing this the last 2-3 weeks whenever I email the list...is it
>> just me???
>>
>>
>> This is the mail system at host sqlite.org.
>>
>> I'm sorry to have to inform you that your message could not
>> be delivered to one or more recipients. It's attached below.
>>
>> For further assistance, please send mail to postmaster.
>>
>> If you do so, please include this problem report. You can
>> delete your own text from the attached returned message.
>>
>>   The mail system
>>
>> : mail forwarding loop for
>> sqlite-users@sqlite.org
>>
>>
>>
>> Michael D. Black
>> Senior Scientist
>> Northrop Grumman Mission Systems
>>
>>
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>

--
Puneet Kishor http://www.punkish.org  
Carbon Model http://carbonmodel.org  
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org 

Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu 

---
Assertions are politics; backing up assertions with evidence is science
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Pavel Ivanov

> This is interesting. I often have situations where I SELECT something
> and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
> iterate through the results.
>
> Is this what you mean by your statement? If yes, how should such
> situations be avoided, and why?

If you issue BEGIN statement before you do your SELECT then yes,
that's what I'm talking about (and I said how to avoid it - issue
BEGIN IMMEDIATE instead of BEGIN). If you don't issue BEGIN then your
SELECT and UPDATE are executed in different transactions (are you
aware of some races that can happen that way?), so my statement is not
applicable.


Pavel

On Mon, Jun 14, 2010 at 8:44 AM, Robert Latest  wrote:
> On Fri, Jun 11, 2010 at 5:26 PM, Pavel Ivanov  wrote:
>
>> 1. Ensure that you have no transactions started with SELECT and
>> continued with INSERT/DELETE/UPDATE
>
> This is interesting. I often have situations where I SELECT something
> and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
> iterate through the results.
>
> Is this what you mean by your statement? If yes, how should such
> situations be avoided, and why?
>
> Regards,
> robert
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Black, Michael (IS)

Looking at the headers in my loop email I see peter.spi...@*
 
I'll leave the domain blank.
 
Try removing him from the list (I assume he's on the list) and see if the loop 
stops.
 
 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 



From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
Sent: Mon 6/14/2010 8:30 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Mail loop?



On Mon, Jun 14, 2010 at 9:09 AM, Black, Michael (IS)  wrote:

> The problem is that somebody has a .forward or such which loops back to the
> list.  It's probably in the alias expansion of sqlite-users which expands to
> a listfor which a member then expands back to sqlite-users.
>
> The mail logs may show whether it happens locally or if its a remote user.
>  If it's a remote user you should see a log entry complaining about too many
> loops and it may ID the user name involved.
>
>
> I'd check sqlite-users for another sqlite-users@ entry...
>

There is no "sqlite-users" entry in the (2500+) membership list for
sqlite-users.  Nor am I able to find any clues in the header of the bounce
reply.  Another ideas?


>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 7:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> It is not just you.  But I have no idea what the problem is or how to fix
> it.
>
> On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) <
> michael.bla...@ngc.com
> > wrote:
>
> > I've been seing this the last 2-3 weeks whenever I email the list...is it
> > just me???
> >
> >
> > This is the mail system at host sqlite.org.
> >
> > I'm sorry to have to inform you that your message could not
> > be delivered to one or more recipients. It's attached below.
> >
> > For further assistance, please send mail to postmaster.
> >
> > If you do so, please include this problem report. You can
> > delete your own text from the attached returned message.
> >
> >   The mail system
> >
> > : mail forwarding loop for
> > sqlite-users@sqlite.org
> >
> >
> >
> > Michael D. Black
> > Senior Scientist
> > Northrop Grumman Mission Systems
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


--
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Richard Hipp

On Mon, Jun 14, 2010 at 9:09 AM, Black, Michael (IS)  wrote:

> The problem is that somebody has a .forward or such which loops back to the
> list.  It's probably in the alias expansion of sqlite-users which expands to
> a listfor which a member then expands back to sqlite-users.
>
> The mail logs may show whether it happens locally or if its a remote user.
>  If it's a remote user you should see a log entry complaining about too many
> loops and it may ID the user name involved.
>
>
> I'd check sqlite-users for another sqlite-users@ entry...
>

There is no "sqlite-users" entry in the (2500+) membership list for
sqlite-users.  Nor am I able to find any clues in the header of the bounce
reply.  Another ideas?


>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 7:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> It is not just you.  But I have no idea what the problem is or how to fix
> it.
>
> On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) <
> michael.bla...@ngc.com
> > wrote:
>
> > I've been seing this the last 2-3 weeks whenever I email the list...is it
> > just me???
> >
> >
> > This is the mail system at host sqlite.org.
> >
> > I'm sorry to have to inform you that your message could not
> > be delivered to one or more recipients. It's attached below.
> >
> > For further assistance, please send mail to postmaster.
> >
> > If you do so, please include this problem report. You can
> > delete your own text from the attached returned message.
> >
> >   The mail system
> >
> > : mail forwarding loop for
> > sqlite-users@sqlite.org
> >
> >
> >
> > Michael D. Black
> > Senior Scientist
> > Northrop Grumman Mission Systems
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


-- 
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread P Kishor

On Mon, Jun 14, 2010 at 8:09 AM, Black, Michael (IS)
 wrote:
> The problem is that somebody has a .forward or such which loops back to the 
> list.  It's probably in the alias expansion of sqlite-users which expands to 
> a listfor which a member then expands back to sqlite-users.
>
> The mail logs may show whether it happens locally or if its a remote user.  
> If it's a remote user you should see a log entry complaining about too many 
> loops and it may ID the user name involved.
>


Happened to me a few days ago. It would be a very bad design on the
part of the mail list manager software if one errant user could cause
bad behavior to percolate to everyone on the list.


>
> I'd check sqlite-users for another sqlite-users@ entry...
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
> Sent: Mon 6/14/2010 7:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Mail loop?
>
>
>
> It is not just you.  But I have no idea what the problem is or how to fix
> it.
>
> On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS) > wrote:
>
>> I've been seing this the last 2-3 weeks whenever I email the list...is it
>> just me???
>>
>>
>> This is the mail system at host sqlite.org.
>>
>> I'm sorry to have to inform you that your message could not
>> be delivered to one or more recipients. It's attached below.
>>
>> For further assistance, please send mail to postmaster.
>>
>> If you do so, please include this problem report. You can
>> delete your own text from the attached returned message.
>>
>>                   The mail system
>>
>> : mail forwarding loop for
>> sqlite-users@sqlite.org
>>
>>
>>
>> Michael D. Black
>> Senior Scientist
>> Northrop Grumman Mission Systems
>>
>>
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
>
> --
> -
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Black, Michael (IS)

The problem is that somebody has a .forward or such which loops back to the 
list.  It's probably in the alias expansion of sqlite-users which expands to a 
listfor which a member then expands back to sqlite-users.

The mail logs may show whether it happens locally or if its a remote user.  If 
it's a remote user you should see a log entry complaining about too many loops 
and it may ID the user name involved.

I'd check sqlite-users for another sqlite-users@ entry...

Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems

From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp
Sent: Mon 6/14/2010 7:46 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Mail loop?

It is not just you.  But I have no idea what the problem is or how to fix
it.

On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS)  wrote:

> I've been seing this the last 2-3 weeks whenever I email the list...is it
> just me???
>
>
> This is the mail system at host sqlite.org.
>
> I'm sorry to have to inform you that your message could not
> be delivered to one or more recipients. It's attached below.
>
> For further assistance, please send mail to postmaster.
>
> If you do so, please include this problem report. You can
> delete your own text from the attached returned message.
>
>   The mail system
>
> : mail forwarding loop for
> sqlite-users@sqlite.org
>
>
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>

--
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mail loop?

2010-06-14 Thread Richard Hipp

It is not just you.  But I have no idea what the problem is or how to fix
it.

On Mon, Jun 14, 2010 at 8:43 AM, Black, Michael (IS)  wrote:

> I've been seing this the last 2-3 weeks whenever I email the list...is it
> just me???
>
>
> This is the mail system at host sqlite.org.
>
> I'm sorry to have to inform you that your message could not
> be delivered to one or more recipients. It's attached below.
>
> For further assistance, please send mail to postmaster.
>
> If you do so, please include this problem report. You can
> delete your own text from the attached returned message.
>
>   The mail system
>
> : mail forwarding loop for
> sqlite-users@sqlite.org
>
>
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


-- 
-
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Mail loop?

2010-06-14 Thread Black, Michael (IS)

I've been seing this the last 2-3 weeks whenever I email the list...is it just 
me???
 

This is the mail system at host sqlite.org.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

   The mail system

: mail forwarding loop for sqlite-users@sqlite.org


 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 
 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Avoiding Database Is Locked Error

2010-06-14 Thread Robert Latest

On Fri, Jun 11, 2010 at 5:26 PM, Pavel Ivanov  wrote:

> 1. Ensure that you have no transactions started with SELECT and
> continued with INSERT/DELETE/UPDATE

This is interesting. I often have situations where I SELECT something
and then do manipulations (INSERT/DELETE/UPDATE) on the db as I
iterate through the results.

Is this what you mean by your statement? If yes, how should such
situations be avoided, and why?

Regards,
robert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] output problem

2010-06-14 Thread Black, Michael (IS)

The command-line interface is not multi-threaded so it all executes in sequence.
I can't imagine how many questions/problems would be on this list if it were 
multi-threaded...yikes!!
 
 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 



From: sqlite-users-boun...@sqlite.org on behalf of Mark
Sent: Mon 6/14/2010 12:26 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] output problem



Hello,

re-visiting this, thanks for the previous help, just a question on timing.  Do 
the commands execute in order, that is, does the .read finish before the 
.output / .dump starts.  It's a timing issue where the programme is waiting on 
the creation of the dump as a signal to finish, but the .read could take maybe 
10 seconds or more.

 .read UnPop.sql
.output C:\done.txt
.dump dbinfo
.quit

mtia
Mark
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Locking issue on NFS filesystem

2010-06-14 Thread Prakash Reddy Bande

Hi,

Do you mean I shall use 

int sqlite3_open_v2(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb, /* OUT: SQLite db handle */
  int flags,  /* Flags */
  const char *zVfs/* Name of VFS module to use */
);

With the last argument "unix-dotfile".

BTW I am using it just as one uses database and our app also has connectors to 
client/server RDBMS.

We use sqlite in a mode where app is used for in a mode where only one process 
uses it and moreover the process is single threaded too.

Regards,

Prakash

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On 
Behalf Of Roger Binns [rog...@rogerbinns.com]
Sent: Monday, June 14, 2010 8:30 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Locking issue on NFS filesystem

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote:
> Our application is a simple desktop application with a simple install and run 
> setup. It is not possible to tell users to apply workaround of sharing the 
> drive via SMB etc.

BTW SMB won't be much better than NFS.  (A lot of things have to line up right.)

You haven't specified if you are using SQLite because it is a convenient
file format or because the transactions and durability matter.  If it is the
latter then you cannot use a networked filesystem.

> I was hoping we have a way to enable dot file locking.

It is available by default.  Use "unix-dotfile" as the VFS name in your open
call.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkwWIP8ACgkQmOOfHg372QT6YQCZAVqZLFg94FlljT7PkZz0jkxP
RH8AoI2daz7YpQ3K7aYNVkG4Qpojqhdf
=jh3O
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Locking issue on NFS filesystem

2010-06-14 Thread Roger Binns

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote:
> Our application is a simple desktop application with a simple install and run 
> setup. It is not possible to tell users to apply workaround of sharing the 
> drive via SMB etc.

BTW SMB won't be much better than NFS.  (A lot of things have to line up right.)

You haven't specified if you are using SQLite because it is a convenient
file format or because the transactions and durability matter.  If it is the
latter then you cannot use a networked filesystem.

> I was hoping we have a way to enable dot file locking.

It is available by default.  Use "unix-dotfile" as the VFS name in your open
call.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkwWIP8ACgkQmOOfHg372QT6YQCZAVqZLFg94FlljT7PkZz0jkxP
RH8AoI2daz7YpQ3K7aYNVkG4Qpojqhdf
=jh3O
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] output problem

2010-06-14 Thread Mark

Hello,

re-visiting this, thanks for the previous help, just a question on timing.  Do 
the commands execute in order, that is, does the .read finish before the 
.output / .dump starts.  It's a timing issue where the programme is waiting on 
the creation of the dump as a signal to finish, but the .read could take maybe 
10 seconds or more.

 .read UnPop.sql
.output C:\done.txt
.dump dbinfo
.quit

mtia
Mark
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Locking issue on NFS filesystem

2010-06-14 Thread Prakash Reddy Bande

Hi,

Our application is a simple desktop application with a simple install and run 
setup. It is not possible to tell users to apply workaround of sharing the 
drive via SMB etc.
I was hoping we have a way to enable dot file locking. For Mac OS X, sqlite 
allows SQLITE_ENABLE_LOCKING_STYLE compile option, why not leverage that for 
NFS issues too?
May be I am completely wrong, but I feel dot file locking may work as long as 
file read/write/execute permissions are available.

Switching SQLITE_ENABLE_LOCKING_STYLE on RHEL resulted in compile errors. There 
is no configure option but by setting CFLAGS, CCFLAGS I tried compile sqlite 
with this option.

Regards,

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On 
Behalf Of Simon Slavin [slav...@bigfraud.org]
Sent: Sunday, June 13, 2010 10:38 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Locking issue on NFS filesystem

On 14 Jun 2010, at 3:16am, Prakash Reddy Bande wrote:

> I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5 
> (But use caution: this locking mechanism might not work correctly if the 
> database file is kept on an NFS filesystem.)
>
> The question is, do we have a workaround. Our application has to store data 
> in user home directory (RHEL/SLES/CentOS) and the home directory might be on 
> a NFS device (as is my home directory).
> stat -f -c %X /users/prakash returns nfs.

Which version of NFS ?  Locking was introduced in version 4.  However, locking 
even under NFS sucks.  That warning in the SQLite FAQ isn't there because the 
writers of SQLite are bad programmers, it's there because locking under many 
NFS installations is not implemented properly.

You may have an alternative of accessing your NFS drive as a shared drive.  If 
you do this, then locking is implemented by the networking protocol, not by the 
driver of the space being shared.  So if you have a way of sharing your NFS 
drive via SMB or AFS, or some other common space-sharing system, you might be 
able to get around the NFS problems completely.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-14 Thread Alexey Pechnikov

2010/6/11 Igor Tandetnik :
> SQLite allows "naked" non-grouped columns as an extension (which is 
> occasionally useful).

And this is needed as replacement of the "distinct on" clause. I don't
know other way to translate many queries from PostgreSQL to SQLite.

-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

45 matches

Mail list logo