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.