Re: PGACCESS Error Relative Path @ export table

From: "John L(dot) Turner" <jlt(at)wvinter(dot)net>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: 2002-08-01 08:35:09
Message-ID: 200208010835.09014.jlt@wvinter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Oliver Elphick, wanted me to know...
> On Wed, 2002-07-31 at 15:45, John L. Turner wrote:
> > > > SO that leads to the bottom line Question:
> > > > How does a user in postgresql obtain permissions to other directories
> > > > ?
> > >
> > > This is at the OS level. Pgaccess is really only accessing the file via
> > > the filesystem of the OS that you are running. You need to make sure
> > > that the user you start PGAccess with has permissions for those
> > > files/directories. For example, on Unix machines, you would use chmod.
> > > If you are on a machine that is maintained by someone else, then you
> > > would need to ask that person to set the permissions correctly for you.
>
> ...
>
> > 3) I started pgaccess as user jlt ( normal user me ). @ /home/jlt
> > Within pgaccess, USERS tab, I added jlt (me) as a user.
>
> Your own user name is irrelevant, because it is not you but the backend
> which is trying to write the file. Therefore the relevant user is
> 'postgres' (if that is the user that started the postmaster).

Thank you for the reply !

Final question on that subject would be:

What is the purpose of the List of users that is set in:
pgaccess [ Tab: Users ] ?

I noted that postgres is not in that list in the demo database supplied:
............. < formdemo.sql

Regards,
John

--
John

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Corey Gibbs 2002-08-01 15:03:40 HEADS UP Everyone!
Previous Message Ahmad Munif 2002-08-01 05:18:22 Getting "unknown host name ..." complied with static library ?