Re: Howto prevent write based on date

"Fmiser" <fmiser(at)gmail(dot)com> wrote in message
news:20050504113559(dot)6529e8cf(dot)fmiser(at)gmail(dot)com(dot)(dot)(dot)
> I'm a newbie to database admin, but I'm not afraid to try - but this one
> has me stumped.
>
> I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly)
> Debian Testing, i386.
>
> My fiscal year is over and I would _like_ to prevent any changes to the
> data from last year.

A simple trigger would work well. A rule could do it too, but rules can
have gotchas if you don't know exactly what you are doing, and triggers give
finer grained control, because you get to use procedural logic.

>
> I looked/searched in the manual, but I don't even know what to call what
> it is that I'm trying to do!
>
> "lock" has another meaning for databases. :)
>
> "Write" seems to bring up lots of user-related stuff.
>
> So, I'm hoping one of you geniuses can tell me where to look, what to
> look for, or how to do it. *smile*
>
> Thanks!
>
> Philip, wanabe-admin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>