Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql on SuSE 7.1 with reiserfs

postgresql on SuSE 7.1 with reiserfs

From
Jose Manuel Lorenzo Lopez
Date:
Hello community,

anyone experienced problems using postgresql distribution
on SuSE 7.1 with reiserfs???

I noticed the following problem:

When creating a table 'tableA' as User A I can not insert in this
table with User A. The error message is always:

ERROR:  tableA: Permission denied.

The only way to insert data in the created table is to insert
with admin user postgres.

SuSE 7.1 ships with postgresql 7.0.2

Thanks in advance for your help!

Best Regards

José Manuel Lorenzo López

Re: postgresql on SuSE 7.1 with reiserfs

From
Date:
On Thu, 7 Jun 2001, Jose Manuel Lorenzo Lopez wrote:

> Hello community,
>
> anyone experienced problems using postgresql distribution
> on SuSE 7.1 with reiserfs???

Yes without any problems.

>
> I noticed the following problem:
>
> When creating a table 'tableA' as User A I can not insert in this
> table with User A. The error message is always:
>
> ERROR:  tableA: Permission denied.

Seems to be a grant problem or the user is not known to the database.
Have you created the user with createuser?

Regards Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                     E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services       Adlergasse 5, 4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: postgresql on SuSE 7.1 with reiserfs

From
Penguin
Date:
On Thu, Jun 07, 2001 at 11:37:34AM +0200, Jose Manuel Lorenzo Lopez wrote:

>Hello community,
>
>anyone experienced problems using postgresql distribution
>on SuSE 7.1 with reiserfs???
>
>I noticed the following problem:
>
>When creating a table 'tableA' as User A I can not insert in this
>table with User A. The error message is always:
>
>ERROR:  tableA: Permission denied.

What has reiserfs has got to do with it ?

Does User A has got insert permissions to the table. If not use GRANT.
Who is the owner of the table. If it is not User A than using GRANT your
will have to give him permission to do certain things such as insert,
update etc.

HTH

Warm Regards

--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA

Email ID : Mail@dempos.com, rfowkar@yahoo.com
Web Site : http://www.dempos.com