Re: Postgres database access problem - Mailing list pgsql-novice

From
Subject Re: Postgres database access problem
Date
Msg-id 20050126232157.92569.qmail@web52409.mail.yahoo.com
Whole thread Raw
In response to Postgres database access problem  (Inpreet Singh <Singh.Inpreet@netsity.com>)
List 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.Inpreet@netsity.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

pgsql-novice by date:

Previous
From: Eduardo Vázquez Rodríguez
Date:
Subject: Re: Postgres 8.0 on FAT32
Next
From: Alexander Borkowski
Date:
Subject: Re: SQL and function reference?