Re: Synchronize filenames in table with filesystem
От | Bret |
---|---|
Тема | Re: Synchronize filenames in table with filesystem |
Дата | |
Msg-id | 001a01ca72dd$96da53b0$0d00a8c0@bjsworkstation обсуждение исходный текст |
Ответ на | Re: Synchronize filenames in table with filesystem (Steve Atkins <steve@blighty.com>) |
Ответы |
Re: Synchronize filenames in table with filesystem
|
Список | pgsql-general |
> -----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.
В списке pgsql-general по дате отправления: