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(at)thedesignexperience(dot)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