<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Daniel T. Staal wrote:
<blockquote
cite="mid54442(dot)63(dot)172(dot)115(dot)138(dot)1157750321(dot)squirrel(at)MageHandbook(dot)com"
type="cite">
<pre wrap="">On Fri, September 8, 2006 4:51 pm, Solomon Asare said:
</pre>
<blockquote type="cite">
<pre wrap="">Hi All,
pls, is there an Insert only version of postgreql or any other known
database? NO deletes, no updates. Inserts only! Any leads, please?
</pre>
</blockquote>
<pre wrap=""><!---->
You can create an account that only has insert access, if that's what you
want.
Otherwise... I can't think of why a database would want to ship that way.
If you don't want to use those features, you don't have to use them.
Daniel T. Staal</pre>
</blockquote>
<br>
Another method would be to put in code inside of update triggers
and delete triggers to prevent updates and deletes. I have never tried
that in PostGreSql before, but
i have done something similar in another DBMS. The only way to stop
people from reading the data (though selects) would be to limit the
access of the account, which that has already been noted.<br>
<br>
cyrus<br>
</body>
</html>