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.
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 -----
To: "Inpreet Singh" <Singh(dot)Inpreet(at)netsity(dot)com>;
Sent: Thursday, January 27, 2005 4:51 AM
Subject: Re: [NOVICE] Postgres database access problem
> 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
> 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!
In response to
pgsql-novice by date
|Next:||From: Rajan Bhide||Date: 2005-01-27 07:59:51|
|Subject: Compilation error on Solaris for Postgres-8.0.0|
|Previous:||From: John DeSoi||Date: 2005-01-27 06:11:09|
|Subject: Re: Two copies of every mail!|