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

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

2010-01-26 Thread Craig Ringer
On 27/01/2010 1:09 AM, Keresztury Balázs wrote: 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 a

[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