Re: BLOBs and a virtual file system

Peter Martini writes: 

> Lately I've been planning work on a patch to postgres and linux on my
> system to allow access to BLOBs as a virtual filesystem, so I can see
> any file I put in there even through network shares while avoiding
> duplication / broken link issues.  Does this sound like something worth
> doing / is there a better way to safely reference files from both inside
> and outside postgres? 
> 

I have been looking into using the Tcl VFS features for this kind of thing. 
I work with AOLserver and PostgreSQL so I have Tcl and PostgreSQL available 
to me. 

http://nnsa.dl.ac.uk/MIDAS/manual/ActiveTcl8.4.4.0-html/tclvfs/doc/vfs.html 

I haven't thought about accessing the VFS from inside PostgreSQL though. 

Dave Bauer
dave@thedesignexperience.org 


> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match