<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16444"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=571004720-04122009><FONT color=#0000ff
size=2 face=Arial> > </FONT></SPAN>And a comment:<BR><BR><SPAN
class=571004720-04122009><FONT color=#0000ff size=2 face=Arial> <FONT
color=#000000 size=3 face="Times New Roman">>
</FONT> </FONT></SPAN>Think *Views*! ... hiding this complexity in views
will make your life easier plus it will not need changes in clients. Clients
connecting to a PostgreSQL DB can use the tables like they normally do, and
clients that want to leverage the versioning aspect of it can use the versioning
stored procedures (i.e set_current_version('myversion')).<BR><BR><SPAN
class=571004720-04122009><FONT color=#0000ff size=2 face=Arial> <FONT
color=#000000 size=3 face="Times New Roman">> </FONT> </FONT></SPAN>My
two cents,<BR><BR><SPAN class=571004720-04122009><FONT color=#0000ff size=2
face=Arial> <FONT color=#000000 size=3 face="Times New Roman">>
</FONT> </FONT></SPAN>- Ragi<SPAN class=571004720-04122009><FONT
color=#0000ff size=2 face=Arial> </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=571004720-04122009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=571004720-04122009><FONT color=#0000ff
size=2 face=Arial>Just a note. Views are great, but to many applications
they don't see primary keys and when they don't sadly views appear as
read-only even if you make them updateable. Just something to
consider, that they are sadly not as transparent as they should be. Think
geoserver for example.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=571004720-04122009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=571004720-04122009><FONT color=#0000ff
size=2 face=Arial>Regina</FONT> </SPAN><BR></DIV></BODY></HTML>