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