Steven Brown <swbrown@xxxxxxxx> writes:
> I'm granting access to insert/update/delete rows of a table to people,
> but I don't want all future inserts to fail if they decided to change
> an id (which they obviously shouldn't, but they /can/). It makes for
> a fragile system.
If it shouldn't happen, you should enforce that with a trigger. Easy
enough to do.
But giving access to an SQL prompt to people who don't know why you
shouldn't change a PK ID scares me. :)
-Doug
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
