Re: [pgadmin-support] some window sizes are not ok

2011-01-06 Thread Susanne Ebrecht
Hello Guillaume, On 05.01.2011 09:23, Guillaume Lelarge wrote: Screen size: 1024 x 600 (16:9) You won't have a good experience with such a small display. IIRC, you need at least 1024x768. Let me point out something here: 600 is the size of eeepc and other notebooks. Before I wrote my ema

[pgadmin-support] pg_hba.conf editor is buggy

2011-01-06 Thread damien clochard
hi guys, Last month during a PG training, i found a very bad behaviour from pgadmin. Here's the step to follow : 0- backup your pg_hba.conf 1- launch pgadmin 2- edit the pg_hba.conf 3- Add a new line with an error inside the CIDR address. For example : host all all 10.224.24.26 trust 4- save 5

[pgadmin-support] What is considered a "slow processes"

2011-01-06 Thread Benjamin Krajmalnik
While playing around with pgadmin to see the state of running queries, I noticed that all of the queries are falling under the category of "slow processes" or "idle process". Some of the process whose query is showing as idle are tagged as idle processes, while some are tagged as slow processes.

Re: [pgadmin-support] pgAdmin v1.12.2: SQL output grid font base

2011-01-06 Thread Rainer Kuhi
I could live with Courier New as the Editor and Output grid font, but I really need to see underscore symbols without dragging the cells taller. http://img23.imageshack.us/i/pgadmin1122font.png/ (notice missing underscores around "i") and using Tahoma for coding is not so funny ;) or what would y

Re: [pgadmin-support] Database selector

2011-01-06 Thread Guillaume Lelarge
Le 28/12/2010 20:18, Erwin Brandstetter a écrit : > On 28.12.2010 19:01, Guillaume Lelarge wrote: >> Le 28/12/2010 18:41, Erwin Brandstetter a écrit : >>> On 29.10.2010 08:21, Guillaume Lelarge wrote: Le 28/10/2010 00:33, Dave Page a écrit : > On Thu, Oct 28, 2010 at 5:25 AM, Guillaume Lel

Re: [pgadmin-support] 1.12.1 - cannot dump from older server versions

2011-01-06 Thread Guillaume Lelarge
Le 03/01/2011 13:30, jan-peter.seif...@gmx.de a écrit : > [...] >> Le 07/12/2010 10:45, Jan-Peter Seifert a écrit : >>> Hello, >>> >>> I have problems dumping databases on older server versions (e.g. 8.4) >> with pgAdmin 1.12.1. It seems to enter an endless loop after clicking 'OK'. >> It doesn't m

Re: [pgadmin-support] Database Port Problem in PostgreSQL Installation.

2011-01-06 Thread Dave Page
On Thu, Jan 6, 2011 at 11:05 AM, Guillaume Lelarge wrote: > Le 06/01/2011 12:01, shubhadeep chattopadhyay a écrit : >> first fo all thanks for giving the reply.Now the think is how to set the >> port in the JDBC connection.Where i have to write this?please reply as soon >> as possible >> > > I don

Re: [pgadmin-support] feature request

2011-01-06 Thread Guillaume Lelarge
Le 06/01/2011 12:02, Grazvydas Valeika a écrit : > >> Yeah, this is something we would like to have. Probably displaying the >> beginning of the string, and then an ellipsis. And you will have the >> complete content in another window. But we need to find time to work on >> this. >> >> Thanks for

Re: [pgadmin-support] Database Port Problem in PostgreSQL Installation.

2011-01-06 Thread Guillaume Lelarge
Le 06/01/2011 12:01, shubhadeep chattopadhyay a écrit : > first fo all thanks for giving the reply.Now the think is how to set the > port in the JDBC connection.Where i have to write this?please reply as soon > as possible > I don't know, I don't use JDBC. But I guess in the JDBC connection strin

Re: [pgadmin-support] feature request

2011-01-06 Thread Grazvydas Valeika
Yeah, this is something we would like to have. Probably displaying the beginning of the string, and then an ellipsis. And you will have the complete content in another window. But we need to find time to work on this. Thanks for your request. This would be great. But to be real, for newbie li

Re: [pgadmin-support] PostgreSQL 8.3: Start service Error message

2011-01-06 Thread Guillaume Lelarge
Le 05/01/2011 12:51, Phifi a écrit : > > Computer 2 (POS): > I get an error message "Could not connect to server: Connection timed out. > Is the server running and accepting TCP/IP connections? > Computer 1 (Server): > When i click "Start service" for the PostgreSQL i get this message: "Local > Co

Re: [pgadmin-support] Inserting data from one database to another using stored functions

2011-01-06 Thread Guillaume Lelarge
Hi, Le 06/01/2011 07:01, Benjie Buluran a écrit : > [...] > I'm stumped on this question for over 3 days now. > > I need to run a stored function in Database A ("sf DBa") which calls a > stored function in Database B ("sf DBb"). > > Here's "sf DBa": > > CREATE OR REPLACE FUNCTION sp_update_seri

Re: [pgadmin-support] Database Port Problem in PostgreSQL Installation.

2011-01-06 Thread Guillaume Lelarge
Hi, Le 06/01/2011 11:34, shubhadeep chattopadhyay a écrit : > [...] > My Name is Shubhadeep Chattopadhyay.I am Software Developer in a IT Company > in india.I have some problem with postgre sql installation when I am > installing adempiere on my machine.To install postgresql the default > database

[pgadmin-support] Database Port Problem in PostgreSQL Installation.

2011-01-06 Thread shubhadeep chattopadhyay
hello dear My Name is Shubhadeep Chattopadhyay.I am Software Developer in a IT Company in india.I have some problem with postgre sql installation when I am installing adempiere on my machine.To install postgresql the default database port is 5432 but in my machine the 5432 port is not free.Then if

Re: [pgadmin-support] feature request

2011-01-06 Thread Guillaume Lelarge
Le 06/01/2011 10:01, Grazvydas Valeika a écrit : > [...] > I would like to have an opportunity to see that content of query result > cell is too long to display. > > F.e. situation: > I have query with array_agg function in one column. Most of rows bring > up to 20 values, some ~100, only one row

Re: [pgadmin-support] pgAdmin Crashes When Opening a *.sql File From Windows Explorer

2011-01-06 Thread Dave Page
Dhiraj, Can you take a look at this issue please? Thanks! On Tue, Jan 4, 2011 at 10:37 PM, Russell L. Galyon wrote: > PGAdmin Version 1.12.2 (Dec 13 2010, REL-1_12_2) > > Workstation - Windows XP x64 SP2 > > > > When I right click on a *.sql file in Windows Explorer and select Open With > pgAdm

[pgadmin-support] feature request

2011-01-06 Thread Grazvydas Valeika
Hi, I would like to have an opportunity to see that content of query result cell is too long to display. F.e. situation: I have query with array_agg function in one column. Most of rows bring up to 20 values, some ~100, only one row brings ~700 integer values, but in pgAdmin result grid this

[pgadmin-support] Inserting data from one database to another using stored functions

2011-01-06 Thread Benjie Buluran
Hi pgAdmin Support! I'm stumped on this question for over 3 days now. I need to run a stored function in Database A ("sf DBa") which calls a stored function in Database B ("sf DBb"). Here's "sf DBa": CREATE OR REPLACE FUNCTION sp_update_serialnumber(pserialnumber character varying, pAc