"Fmiser" <fmiser@xxxxxxxxx> wrote in message news:20050504113559.6529e8cf.fmiser@xxxxxxxxxxxx > 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
