am Tue, dem 16.01.2007, um 18:35:56 +0100 mailte Furesz Peter folgendes: > Hello, > > I have a table named foobar and I don't want to allow from DELETE or > UPDATE its rows. > > I have a table as described below: > foobar(foobar_id, value, is_deleted); > > I don't want to allow directly delete or modify the table's rows. I plan to > make an on before update or delete trigger and > on delete action I update the actual row is_deleted flag, on UPDATE action
I think, you should better use a RULE for this: http://www.postgresql.org/docs/8.2/interactive/rules.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
