Обсуждение: Postgres database access problem
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
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
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 >
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