Luis Castillo <[EMAIL PROTECTED]> writes:
> I would like to know how can I control in my database the rows that a
> user has inserted. I mean many users can insert information in a table
> but when trying to update the information I want that a user can change
> only those rows inserted by him. Is this possible with Postgresql?
Sure, if you add a column that records which user inserted the row, and
then make a BEFORE UPDATE trigger that throws an error if it doesn't
match.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
