[ADMIN] Postmaster will not start???

2001-11-19 Thread Eric Theis
I am running PostgreSQL 7.1.2/3 on Mandrake 8.1. My problem (well my immediate problem) is that the Postmaster will not start. I installed MDK a couple months ago. In that time, Postgres has started fine until a couple days ago. I do not get any messages (either on screen or in syslog), but

[ADMIN] Please help

2001-11-19 Thread Mr OCP
Hi Can anyone help me write a trigger on a table, I have created an audit table for a table and what I want trigger to do is to whenever a record is deleted from the table it should first be inserted into the audit table, just to keep track of whatever records are deleted. Thanks so much for you

[ADMIN] Rules <-> Functions <-> Permissions

2001-11-19 Thread AKACIA
Hi, I'm trying create a SECURE TIER in my DB. I need "dummys" tables that accept INSERTS from any users, then execute a RULE that insert the datas into the REAL table. The REAL tables accept INSERT only from "postgres user". This work fine ! But when I need the RULE calls a FUNCTION (plpgsql)

[ADMIN] grant access

2001-11-19 Thread Manuel Trujillo
Hi. I'm using a postgresql-7.1.3 compiled into a Debian Potato. I need to grant access "select" to one user in all tables. How can I make this into "one command", without make "grant 1 to x", "grant 2 to x", etc, etc Thank you very much, and excuse my bad english. -- Manuel Trujillo