trigger or function?

From: adeon <adeon(at)tlen(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: trigger or function?
Date: 2003-06-14 00:37:01
Message-ID: 200306140237.01255.adeon@tlen.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Nuzum 2003-06-14 00:55:12 Re: Postgres performance comments from a MySQL user
Previous Message Kaare Rasmussen 2003-06-13 23:04:29 Re: [HACKERS] SAP and MySQL ... [and Benchmark]