Skip site navigation (1) Skip section navigation (2)

Re: BUG #5791: Tables are not viewing through pgadmin

From: "Benoygopal" <benoy(at)cdactvm(dot)in>
To: "'Dave Page'" <dpage(at)pgadmin(dot)org>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5791: Tables are not viewing through pgadmin
Date: 2011-01-19 04:20:42
Message-ID: 000f01cbb790$48e14e90$daa3ebb0$@in (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-bugs
Dear Dave,
Tables will not visible even after refreshing the tree view and after
restarting the PC as well.
It not predictable when the table will start displaying again. Some time the
tables displayed in the next day as well.
However we could able to login to the database,views up to schema but inside
schema nothing is visible.
But we could log and retrieve the data to the tables. Application could able
to use triggers stored procedures etc even it is not visible through
pgadmin. Please suggest any input is required from my side or suggest to
check something related to the postgres database or pgadmin related
configuration files when this condition occurs again.

Regards
Benoygopal
CDAC, Trivandrum.


 

-----Original Message-----
From: Dave Page [mailto:dpage(at)pgadmin(dot)org] 
Sent: 18 January 2011 20:41
To: benoygopal
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5791: Tables are not viewing through pgadmin

On Tue, Jan 18, 2011 at 2:27 PM, benoygopal <benoy(at)cdactvm(dot)in> wrote:
>
> Yes meant the tables are not shown in the treeview.
> Let me explain the sequence of operations.
> While our application is running it will create the database , tables,
> stored procedures, triggers etc. dynamically and  it will be visible
through
> pgAdmin as well. The application is running 24 X 7 and every day new table
> will be created and the table is attached with triggers dynamically. The
> error is very ergodic.And it is not sustain for long days even. Other than
> the dynamic creation of the table we are not modifying anything in the
> machine where the database is loaded. Please suggest what may the reason?
> How I can solve the issue.

Do they show up if you refresh the treeview, or restart pgAdmin? Or
remain permanently invisible?

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


______________________________________
Scanned and protected by Email scanner

In response to

Responses

pgsql-bugs by date

Next:From: Dave PageDate: 2011-01-19 08:12:03
Subject: Re: BUG #5791: Tables are not viewing through pgadmin
Previous:From: Pavel StehuleDate: 2011-01-18 22:49:29
Subject: statement EXECUTE isn't possible call from SPI_execute_with_args function

pgadmin-support by date

Next:From: Dave PageDate: 2011-01-19 08:12:03
Subject: Re: BUG #5791: Tables are not viewing through pgadmin
Previous:From: Jeremy PalmerDate: 2011-01-18 20:57:31
Subject: Re: Calling pgScript from the command line

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group