Mike Nolan wrote on 31.08.2004 21:46:
But should you also prevent DELETE's from that table? Otherwise you could wind up with no rows at all. I guess that would have to be done using a rule...
Why not just revoke the delete privilege?
That was one of my first guesses as well, but then I'm not sure if you can revoke DELETE and INSERT privilege from the owner of the table...
Thomas
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
