Re: [GENERAL] create role in a pl/pgsql trigger

2010-01-27 Thread Keresztury Balázs
Thanks Craig, this one worked! Balazs -Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Wednesday, January 27, 2010 12:34 AM To: Keresztury Balázs Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] create role in a pl/pgsql trigger On 27/01/2010 1:09

[GENERAL] create role in a pl/pgsql trigger

2010-01-26 Thread Keresztury Balázs
hi, I would like to write a trigger on a table which contains detailed information about users. If I add a new user to this table, I'd like this trigger to add the user to the database as well. Later I also want to implement triggers for updating and deleting, but I got stuck at the first part of

[GENERAL] getting all groups where a user belongs to

2009-09-06 Thread Keresztury Balázs
hi, I'm currently developing a business software, and I faced a problem just a few days ago. My users are currently using their own credentials for logging in to PostgreSQL server (this makes auditing, logging a lot easier). There are several groups, and the groups can inherit their parents'