Re: [pgadmin-support] [BUGS] BUG #5791: Tables are not viewing through pgadmin

2010-12-20 Thread Dave Page
On Mon, Dec 20, 2010 at 4:37 AM, Benoygopal  wrote:
> Dear PgAdmin Support Team,
>
> In our research and implementation projects we are using postgres database 
> and pgadmin client as the front end.
> Our application and database are deployed in linux RHEL , Ubuntu and Windows. 
> Using our application continuously data is logged into the database tables 
> and the log tables are created every day. Other than this we have other 
> tables as well to keep our configuration data. The tables are created 
> automatically when we run our application and it can be viewed through the 
> pgadmin client. We are using triggers , stored procedures etc.
>
> Because of some reasons we could not view the tables using pgadmin client 
> (initially we could see all tables, triggers, procedures etc.), however we 
> could able to log the data to the corresponding tables using our programs and 
> the table data can be displayed using the SQL editor in the pgadmin client. 
> When we check the tables from the pgadmin table property count would be zero.
>
> Have you experienced this type of issue any time? What is the reason for this?

Do you mean the tables don't show up in the treeview? I assume you've
refreshed, after the tables have been created.

Are you looking in the right schema? Perhaps the search path means the
tables are being created somewhere other than where you expect.

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

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

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-20 Thread Michael Willekes
The history file is only 14 MB (4219 lines long) but the PostGIS geometry
columns (auto-generated from a .SHP file) result in individual INSERT
statements that are as much as 50 characters long.



This file is used by the query tool since 1.12. Do you know which size
> it was?
>
>
> --
> Guillaume
>  http://www.postgresql.fr
>  http://dalibo.com
>


Re: [pgadmin-support] pgAdmin Query Tool hangs when working with GIS data

2010-12-20 Thread Guillaume Lelarge
Le 20/12/2010 16:39, Michael Willekes a écrit :
> The history file is only 14 MB (4219 lines long) but the PostGIS geometry
> columns (auto-generated from a .SHP file) result in individual INSERT
> statements that are as much as 50 characters long.
> 

Is it possible to get the SQL query? by private mail. My idea is to try
on my laptop and see if I found any issue. Thanks.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support