Re: administering files, data type "file"
От | Scott Marlowe |
---|---|
Тема | Re: administering files, data type "file" |
Дата | |
Msg-id | 1087710987.28062.57.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | administering files, data type "file" (Daniel Heiserer <danielheiserer@yahoo.com>) |
Список | pgsql-general |
On Sat, 2004-06-19 at 06:26, Daniel Heiserer wrote: > Hi, > I want to administer files with postgres. > When I "import" a file to postgres I also > submit certain atributes the file has. > Such as filetype or specific properties I know > about the file (not the standard stuff like > the OS knows about the file as date,and size) > I want that postgres then copies the file to a > save place and write and read protects it. > Once I query for certain attributes I submitted before > and I get a hit I should be able to get the filename > from postgres including a "read" permission. > I also want to be able to create a new file. > After submitting the properties the file has > postgres should give me a filename and write > permission > for that file. After finishing my creation of the file > I want that postgres stops read and write access to > that file. I'd think you'd need to create rules and triggers with user defined functions to do it. But it's doable. It's not a simple project in any database, and it certainly isn't a native behavior of any databases I know.
В списке pgsql-general по дате отправления: