Re: Postgres database access problem

From: <operationsengineer1(at)yahoo(dot)com>
To: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgres database access problem
Date: 2005-01-26 23:21:57
Message-ID: 20050126232157.92569.qmail@web52409.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

inpreet,

i believe the superuser who created the database and
has all privileges has an id of 1, not 100.

100 is the id where added users start.

at least that is what happened with my system
recently.

find the user with id=1. pgadminIII should list the
id when you click on the user.

good luck.

--- Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com> wrote:

> Hello,
>
> I am using postgres 7.3.4. I am trying to retrieve
> data from already
> existing database. I am using postgres, which is
> super user of my
> database in php.ini. But when I am trying to
> retrieve data following
> error is coming
> pg_class_aclcheck: invalid user id 100
>
> please help me in rectifying this problem.
>
> Inpreet Singh
>


__________________________________
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
http://my.yahoo.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Borkowski 2005-01-26 23:26:19 Re: SQL and function reference?
Previous Message Eduardo Vázquez Rodríguez 2005-01-26 22:14:39 Re: Postgres 8.0 on FAT32