Re: [sqlite] uncertainty how load_extension is supposed to work

2010-11-15 Thread Chris Wolf
Richard Hipp wrote: > On Mon, Nov 15, 2010 at 7:39 AM, Chris Wolf wrote: > > >> sqlite> .load mylib >> unknown command or invalid arguments: "load". Enter ".help" for help >> >> ...and it's not listed with ".help" >> >> I have release 3.4.0 on Mac OS 10.5. >> >> >> > Bummer. I guess Le

Re: [sqlite] uncertainty how load_extension is supposed to work

2010-11-15 Thread Richard Hipp
On Mon, Nov 15, 2010 at 7:39 AM, Chris Wolf wrote: > > > sqlite> .load mylib > unknown command or invalid arguments: "load". Enter ".help" for help > > ...and it's not listed with ".help" > > I have release 3.4.0 on Mac OS 10.5. > > Bummer. I guess Leopard compiled with -DSQLITE_OMIT_LOAD_EXTEN

Re: [sqlite] uncertainty how load_extension is supposed to work

2010-11-15 Thread Chris Wolf
Richard Hipp wrote: > On Fri, Nov 12, 2010 at 12:08 PM, Chris Wolf wrote: > > >> I tried to explicitly load an extension via: >> >> sqlite> select load_extension('mylib'); >> SQL error: no such function: load_extension >> >> > > Use the ".load" command in the sqlite3.exe command-line she

Re: [sqlite] uncertainty how load_extension is supposed to work

2010-11-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/12/2010 09:08 AM, Chris Wolf wrote: > If so, does that mean we can't use the out-of-the box shell and must > re-compile with a 'C' code change to invoke this? If that's true, why wasn't > this > simply controlled via an environment variable? C

[sqlite] uncertainty how load_extension is supposed to work

2010-11-12 Thread Chris Wolf
I tried to explicitly load an extension via: sqlite> select load_extension('mylib'); SQL error: no such function: load_extension Is this because of the default setting of "enable_load_extension"? http://www.sqlite.org/c3ref/enable_load_extension.html If so, does that mean we can't use the out-o

Re: [sqlite] uncertainty how load_extension is supposed to work

2010-11-12 Thread Richard Hipp
On Fri, Nov 12, 2010 at 12:08 PM, Chris Wolf wrote: > I tried to explicitly load an extension via: > > sqlite> select load_extension('mylib'); > SQL error: no such function: load_extension > Use the ".load" command in the sqlite3.exe command-line shell. > > > Is this because of the default set