On Thu, Jul 24, 2014 at 4:45 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 24 Jul 2014, at 3:38pm, Stephan Beal <sgb...@googlemail.com> wrote: > > > THANK YOU! > > You're welcome. I'm still learning more from this list than I'm putting > out. > Hope we never meet, because i will likely kiss you if we do: [stephan@host:~/cvs/fossil/libfossil/src]$ f-query -e "select * from ckout.vfile limit 1" -S SQL TRACE #1: PRAGMA foreign_keys=OFF; SQL TRACE #2: ATTACH DATABASE '/home/stephan/cvs/fossil/libfossil/_FOSSIL_' AS ckout; ^^^^^^^ that's your baby. SQL TRACE #3: SELECT value FROM vvar WHERE name='repository'; SQL TRACE #4: ATTACH DATABASE '/home/stephan/cvs/fossil/libfossil.fsl' AS repo; SQL TRACE #5: SELECT login FROM user WHERE uid=1; SQL TRACE #6: SELECT value FROM config WHERE name='allow-symlinks'; SQL TRACE #7: SELECT value FROM vvar WHERE name='checkout'; SQL TRACE #8: SELECT uuid FROM blob WHERE rid=5864; SQL TRACE #9: BEGIN TRANSACTION; SQL TRACE #10: select * from ckout.vfile limit 1; id vid chnged deleted isexe islink rid mrid mtime pathname origname 1397 5864 0 0 0 0 2605 2605 1395763875 .fossil-settings/binary-glob NULL SQL TRACE #11: COMMIT; SQL TRACE #12: DETACH DATABASE repo; before your patch, that would have failed with "unknown db" because ckout was only known as "main". So.... [stephan@host:~/cvs/fossil/libfossil/src]$ f com -m "Eureka: Simon Slavin found a way to apply a concrete name to the main db. Seems to work." fsl_cx.c Autosync: http://step...@fossil.wanderinghorse.net/repos/libfossil/index.cgi Round-trips: 1 Artifacts sent: 0 received: 0 Pull finished with 2964 bytes sent, 2238 bytes received New_Version: 5abda43115e11c357aa36a1b7231780767b04c23 Autosync: http://step...@fossil.wanderinghorse.net/repos/libfossil/index.cgi Round-trips: 1 Artifacts sent: 2 received: 0 Sync finished with 5625 bytes sent, 4906 bytes received Resulting in: http://fossil.wanderinghorse.net/repos/libfossil/index.cgi/info/5abda43115e11c357aa36a1b7231780767b04c23 THANK YOU! (But i still think the ability to rename the main would be a useful feature!) -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users