Artistic-HO- IT-Department wrote:
> Hi
>
> I have a user table in which number of users are created in a
> database rather creating postgresql user. We are having only one
> database user, through which we connect database.
OK
> Like Mr. A add intry into table and data is copied into audit table.
> Mr. B edit entry into table and data is copied into audit table. Mr.
> C delete entry into table but it add data into audit table that Mr. B
> delete it(As it was the person who edit last). It saved the whole row
> that was deleted.
> """"How can i make trigger on database that will add userid into
> audit table that Mr. C has deleted the entry."""""
Create a session table and store your user-name there when you connect.
Then the trigger can access the session table for the user-name. You can
use the backend process-id as a key for the table:
SELECT pg_backend_pid()
HTH
--
Richard Huxton
Archonet Ltd