[GENERAL] createuser permssion for group

2006-02-25 Thread Jebus
Is it possible to give a group the the createuser permission ? This way if a user in the group they can create users. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] audit tables adding columns

2006-02-27 Thread Jebus
I am using triggers and table inheritance for my audit tables. Here is the function I am using its straight copy from the docs. CREATE OR REPLACE FUNCTION process_reward_audit() RETURNS "trigger" AS $BODY$ BEGIN IF (TG_OP = 'INSERT') THEN INSERT IN

[GENERAL] autovacuum settings

2006-04-06 Thread Jebus
I am totally new to postgres and I wondering what settings should I be using for autovacuum ? For now I just uncommented all the defaults, is this good enough ? The database is not large but it is a web database so there is a lot of inserts and updates. autovacuum = on #