[HACKERS] Role privileges in PostgreSQL.

2007-05-25 Thread Akmal Akmalhojaev
Hello. I have the following question: where role privileges on working with tables, data bases and so on are stored in PostgreSQL (In what system catalogs?)? Thanks. Akmal.

[HACKERS] Role members

2007-05-21 Thread Akmal Akmalhojaev
Hello! I have the following question. For example I have a role ID1 with members ID2 and ID3. Role ID2 has also members ID4 and ID5. It means that roles ID4 and ID5 are members of ID1. The question: Is there any function in PostgreSQL, that finds all the members of role ID1 - even such members, a

[HACKERS] Creating new system catalog problems.

2007-05-02 Thread Akmal Akmalhojaev
Hello. I wanted to create a new system catalog in Postgres. So I changed the source code. Everything seems to be OK. I compiled it, but now after initdb I receive: $ initdb -D /usr/home/postgres/post1 The files belonging to this database system will be owned by user "postgres". This user must al

[HACKERS] Programming new commands problems.

2007-04-29 Thread Akmal Akmalhojaev
Need help. I want to create new system catalog and extend existing commands - CREATE ROLE and another commands connected with roles. I can't find how to add new features into parser. Can you help me? Thanks. Akmal.