[ADMIN] Book recommendations

2008-03-23 Thread Mikel Lindsaar
SELECT book.title, book.author, book.feedback FROM postgresql_admin_community JOIN books ON book.subject ILIKE '%postgres%' JOIN readings ON readings.reader_id = postgresql_admin_community.id WHERE postgres_admin_community.user_experience_level = 'I have spent years around databases, but never real

Re: [ADMIN] Book recommendations

2008-03-23 Thread Hannes Dorbath
Mikel Lindsaar wrote: I have done this so far by reading a lot of the Postgres manual and every website I can find. Books usually just recycle that information. PostgreSQL's manual is really good today. Add Greg Smith's PostgreSQL Performance Pitstop, a few other sites and you have everything

[ADMIN] permissions on inherited tables

2008-03-23 Thread sriram.dandapani
Is there a way to grant a permission on a table for a role and have that cascade to the child tables ? I have several high volume "daily" partitioned tables that get dropped every week and every time I need to re-grant permission on the new tables created.