Re: Data Versioning

You should be able to easily design a database schema that does what you
want. For example two tables,

files
------
file_id (PK)
file_name text
...

file_versions
-------------
file_version_id (PK)
file_id (FK to files.file_id)
version integer not null
data oid not null
...

Then when your application creates a new file you would insert a row
into both the files and file_versions table. When your application
'updates' a file it just inserts into the file_versions table the new
version.

There is no explicit support for what you are trying to do native, and I
don't know of any other databases that support that type of
functionality either (at least I know Oracle does not).

thanks,
--Barry

Sunit Bhatia wrote:

> Does any body know if pgsql supports any kind of versioning of binary
> objects or data. e.g. If I'm storing a binary file in a row of a table,
> I would want to see different versions of the same biary file. Everytime
> I do a write, the version number should be bumped up !!
>
> Is it possible to do it in pgsql or any other databases.
> I'm using JDBC for connecting to database.
>
> thanks
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>