Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres database access problem

Postgres database access problem

From
Inpreet Singh
Date:
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

Re: Postgres database access problem

From
Date:
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

Re: Postgres database access problem

From
Inpreet Singh
Date:
I saw my database and got that it has no owner so probably I deleted my user
of database accidentally. Now is there a way to create owner of already
existing database in postgres.

Snapshot of my command prompt which shows that there is no current Owner of
my database. so I need to create owner for this table.
XYZ=# \dt
                  List of relations
 Schema |            Name             | Type  | Owner
--------+-----------------------------+-------+-------
 public | account_codes            | table |
 public | accountcodeid            | table |
 public | attendance                  | table |
 public | attendance_details      | table |
 public | audit_trail                 | table |


----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: "Inpreet Singh" <Singh.Inpreet@netsity.com>;
<pgsql-novice@postgresql.org>
Sent: Thursday, January 27, 2005 4:51 AM
Subject: Re: [NOVICE] Postgres database access problem


> 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
>

Re: Postgres database access problem

From
Tom Lane
Date:
Inpreet Singh <Singh.Inpreet@netsity.com> writes:
> I saw my database and got that it has no owner so probably I deleted my user
> of database accidentally. Now is there a way to create owner of already
> existing database in postgres.

Recreate the user with the same sysid as before.

            regards, tom lane