Thread: administering files, data type "file"
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. Can something like that be done with the current version. Are there any successful implementations of that and where can I find them? thanks, daniel ___________________________________________________________ Bestellen Sie Y! DSL und erhalten Sie die AVM "FritzBox SL" für 0. Sie sparen 119 und bekommen 2 Monate Grundgebührbefreiung. http://de.adsl.yahoo.com
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.