trigger or function? - Mailing list pgsql-general

From adeon
Subject trigger or function?
Date
Msg-id 200306140237.01255.adeon@tlen.pl
Whole thread Raw
Responses Re: trigger or function?  (weigelt@metux.de)
List pgsql-general
Hi,

There are many users in a database I'm making.
There is a table in the database, that has a user_id column.
Every user is able to insert, update or delete a record from this table,
but users are only allowed to execute those operations only on their own
records (that ones that have right user_id). How should be user_id checking
performed - in trigger or should I create a functions for every operation
(insert, delete and update)??


adeon

PS: Sorry for my English...


pgsql-general by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: "Matthew Nuzum"
Date:
Subject: Re: Postgres performance comments from a MySQL user