[Lxr-dev] Permission problems with Postgres?

[Malcolm B. <ma...@br...>]

Hi folks,

I've just tried to install Postgres for use with lxr, since I normally 
use MySQL and thought I ought to test both, or at least the install 
instructions.

However, on doing the install, there seems to be a problem with 
permissions.  Specifically, I get permission denied messages when the 
lxr user attempts to insert any values into the database.  Now I'm not 
familiar with postgres, so does anyone else experience this, or am I 
just doing something wrong?

Here's what I did:

createuser lxr
 - I answered "yes" to the permission questions to give lxr lots of rights
createdb -U lxr lxr
psql -U lxr
\i initdb-postgres

Then I tried to run genxref, and it blew up when first trying to insert 
into a table.  Going into psql and looking at the table permissions, it 
shows lxr as the owner for the tables, but only public read access in 
the permissions.  This appears to conflict with the documentation, which 
claims that the owner always has all permissions.

I then did a "grant all" on all the tables to lxr, and after that 
genxref worked fine.  So should I update the initdb-postgres script to 
add the relevant grant statements at the end?  What do others of you who 
use Postgres do - or is it only my setup which is strange.  If it 
matters I'm using Postgres 7.0.3.

Cheers,

Malcolm