public inbox for [email protected]help / color / mirror / Atom feed
Data Versioning 4+ messages / 3 participants [nested] [flat]
* Data Versioning @ 1970-01-01 00:00 Sunit Bhatia <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Sunit Bhatia @ 1970-01-01 00:00 UTC (permalink / raw) To: pgsql-general 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Data Versioning @ 1970-01-01 00:00 Sunit Bhatia <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Sunit Bhatia @ 1970-01-01 00:00 UTC (permalink / raw) To: pgsql-general <html><div style='background-color:'><DIV>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 !!</DIV> <DIV> </DIV> <DIV>Is it possible to do it in pgsql or any other databases. </DIV> <DIV>I'm using JDBC for connecting to database.</DIV> <DIV> </DIV> <DIV>thanks</DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html; ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data Versioning @ 2001-08-02 02:13 Yasuo Ohgaki <[email protected]> parent: Sunit Bhatia <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Yasuo Ohgaki @ 2001-08-02 02:13 UTC (permalink / raw) To: Sunit Bhatia <[email protected]>; +Cc: pgsql-general > 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 !! With PostgreSQL, you can create RULE to keep old values. (Much easier than other DB, thanks to RULE) Refer to PostgreSQL manual for details. Yasuo Ohgaki ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data Versioning @ 2001-08-02 02:46 Barry Lind <[email protected]> parent: Sunit Bhatia <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Barry Lind @ 2001-08-02 02:46 UTC (permalink / raw) To: Sunit Bhatia <[email protected]>; +Cc: pgsql-general; [email protected] 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 > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-08-02 02:46 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1970-01-01 00:00 Data Versioning Sunit Bhatia <[email protected]> 2001-08-02 02:13 ` Yasuo Ohgaki <[email protected]> 2001-08-02 02:46 ` Barry Lind <[email protected]> 1970-01-01 00:00 Data Versioning Sunit Bhatia <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox