I know it would be a hard approach but... perhaps ON DELETE and ON UPDATE
triggers would help?
On 5/11/05, Jay A. Kreibich <jak(at)uiuc(dot)edu> wrote:
>
> On Wed, May 11, 2005 at 03:51:43PM -0400, GGoshen(at)axsone(dot)com scratched on
> the wall:
> > I would like to clarify something.
> > I intend to create the database on a re-writable device (not WORM).
> > At some point, when I no longer want to add/modify the database, I
> > plan to copy it to the WORM device. Then I would like to be able to
> > access the database on the WORM device for reading purposes only.
>
> What you are basically saying is you want a read-only database on a
> CD-R (which is essentially a WORM device). As has been discussed
> many times in the past, Postgres does not support this very well, if
> at all.
>
> -j
>
> --
> Jay A. Kreibich | CommTech, Emrg Net Tech Svcs
> jak(at)uiuc(dot)edu | Campus IT & Edu Svcs
> <http://www.uiuc.edu/~jak> | University of Illinois at U/C
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>