Re: Synchronize filenames in table with filesystem

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Steve Atkins
> Sent: Tuesday, December 01, 2009 9:44 AM
> To: pgsql-general General
> Subject: Re: [GENERAL] Synchronize filenames in table with filesystem
>
>
> On Dec 1, 2009, at 9:19 AM, Ludwig Kniprath wrote:
>
> > Hi List,
> > not another question on how to store files (db or
> filesystem), i decided to use the filesystem.
> >
> > I'm now searching for a trigger, that deletes the physical
> file when deleting a database-record containing the filename
> in one of its fields. Is there a sample somewhere how this
> could be done? I'm runnig PG 8.4 on a windows machine.
>
> I've done that by having the trigger put the name of the file
> to be deleted in a "to be deleted" table. Then an external
> process polls that table and deletes any file it finds in
> there (using listen/notify if you need that to happen
> immediately, but just polling works fine if it's just garbage
> collection).
>
> That has the advantage of not deleting files until the
> transaction commits too.
>
> Cheers,
> Steve
>
>
> --
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

I'm with Ludwig..

Better to have the database perform it's primary function, and stay away
from os chores.