You can also use LISTEN/NOTIFY.
On Tue, Dec 1, 2009 at 6:25 PM, Bret <bret_stern@machinemanagement.com> wrote:
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org
>> [mailto:pgsql-general-owner@postgresql.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@postgresql.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.
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
