[pgadmin-support] Feature request - option to exclude docs when installing

2006-04-04 Thread Miha Radej

Hi!

I have the following feature request: is it possible to add an option 
(maybe at configure time?) which would cause "make install" to exclude 
installation of the documentation (at least the PostgreSQL and Slony docs)?


Thank you,
Miha

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [pgadmin-support] Feature request - option to exclude docs when installing

2006-04-04 Thread Dave Page
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej
> Sent: 04 April 2006 08:57
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Feature request - option to 
> exclude docs when installing
> 
> Hi!
> 
> I have the following feature request: is it possible to add 
> an option (maybe at configure time?) which would cause "make 
> install" to exclude installation of the documentation (at 
> least the PostgreSQL and Slony docs)?

Funny, I had the same thought last night when running 'make install'
into a mac appbundle for the umpteenth time!

/D

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[pgadmin-support] How to use arrow keys to move to other row in grid editing

2006-04-04 Thread Andrus
I edit data in pgAdmin edit grid in Windows XP

To change single column in many rows, I use 3 keys after making change to 
move next column:

tab
down arrow
left arrow

this is VERY inconvenient.

How to change wxGrid or pgAdmin so that down arrow moves to same column in 
next row during cell editing ?

It seems that wxWidgets cell editor does'nt let to use arrow keys for grid 
navigation.


Andrus. 



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Miha Radej

Hello!

I would like to second this request.

Would it be possible/useful perhaps to implement an OOo Calc/Excel - 
like option to define which cell is activated after pressing  
perhaps: above, below, left or right of the current one? IMO it would be 
very convenient to sometimes edit from the ground up and after editing a 
cell and pressing , the cell above the currently altered one 
could be highlighted...


Regards,
Miha

Andrus wrote:

I edit data in pgAdmin edit grid in Windows XP

To change single column in many rows, I use 3 keys after making change to 
move next column:


tab
down arrow
left arrow

this is VERY inconvenient.

How to change wxGrid or pgAdmin so that down arrow moves to same column in 
next row during cell editing ?


It seems that wxWidgets cell editor does'nt let to use arrow keys for grid 
navigation.



Andrus. 


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Andrus
> Would it be possible/useful perhaps to implement an OOo Calc/Excel - like 
> option to define which cell is activated after pressing  perhaps: 
> above, below, left or right of the current one? IMO it would be very 
> convenient to sometimes edit from the ground up and after editing a cell 
> and pressing , the cell above the currently altered one could be 
> highlighted...

There is no urgent need for this if up/down arrow works.
Then

tab moves to next column
shift+tab moves to previous column
up arrow moves line up
down arrow moves line down

Btw. I use news server. How to subscribe this list without receiving e-mail 
like in Postgres mailing lists.
I tried subscribe-nomessage but this fails.

Andrus. 



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Dave Page
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 04 April 2006 10:48
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] How to use arrow keys to move 
> to other row
> 
> Btw. I use news server. How to subscribe this list without 
> receiving e-mail like in Postgres mailing lists.
> I tried subscribe-nomessage but this fails.

Try:

Subscribe nomail

Regards Dave

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Andreas Pflug

Andrus wrote:

I edit data in pgAdmin edit grid in Windows XP

To change single column in many rows, I use 3 keys after making change to 
move next column:


tab
down arrow
left arrow

this is VERY inconvenient.


This is exactly the stuff a base control should deliver, i.e. wxGrid. It 
does so unsatisfactory, and probably will never do better, which is one 
reason why I'd like to get rid of this control (and not just me: most 
developers who once touched that piece of sh^H^Hcode).


Regards,
Andreas

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Dave Page
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Andreas Pflug
> Sent: 04 April 2006 15:25
> To: Andrus
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] How to use arrow keys to move 
> to other row
> 
> Andrus wrote:
> > I edit data in pgAdmin edit grid in Windows XP
> > 
> > To change single column in many rows, I use 3 keys after 
> making change 
> > to move next column:
> > 
> > tab
> > down arrow
> > left arrow
> > 
> > this is VERY inconvenient.
> 
> This is exactly the stuff a base control should deliver, i.e. 
> wxGrid. It does so unsatisfactory, and probably will never do 
> better, which is one reason why I'd like to get rid of this 
> control (and not just me: most developers who once touched 
> that piece of sh^H^Hcode).

Do we know why it's so bad? Is it caused by compromising between
different implementations of grids on different platforms? If so,
perhaps the only answer would be a custom control (urgh).

Regards, Dave

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Andreas Pflug

Dave Page wrote:
 




-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
Andreas Pflug

Sent: 04 April 2006 15:25
To: Andrus
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] How to use arrow keys to move 
to other row


Andrus wrote:


I edit data in pgAdmin edit grid in Windows XP

To change single column in many rows, I use 3 keys after 


making change 


to move next column:

tab
down arrow
left arrow

this is VERY inconvenient.


This is exactly the stuff a base control should deliver, i.e. 
wxGrid. It does so unsatisfactory, and probably will never do 
better, which is one reason why I'd like to get rid of this 
control (and not just me: most developers who once touched 
that piece of sh^H^Hcode).



Do we know why it's so bad? Is it caused by compromising between
different implementations of grids on different platforms? If so,
perhaps the only answer would be a custom control (urgh).


It has been common understanding on wx-dev for quite a while that wxGrid 
should be rewritten from ground to have it implemented in a clean and 
maintainable way. The current 300k source has poor editors, bad key 
handling, ... (you add your stuff here).

If "custom control" means to write a ctlGrid ourselves, well go on
You probably have plenty of spare time :-)


Regards,
Andreas



---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [pgadmin-support] How to use arrow keys to move to other row

2006-04-04 Thread Dave Page
 

> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
> Sent: 04 April 2006 16:22
> To: Dave Page
> Cc: Andrus; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] How to use arrow keys to move 
> to other row
> 
> It has been common understanding on wx-dev for quite a while 
> that wxGrid 
> should be rewritten from ground to have it implemented in a clean and 
> maintainable way. The current 300k source has poor editors, bad key 
> handling, ... (you add your stuff here).
> If "custom control" means to write a ctlGrid ourselves, well go on
> You probably have plenty of spare time :-)

OK, I can probably squeeze something in before dinner :-p

/D

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[pgadmin-support] How install server management instrumentarium without compiling

2006-04-04 Thread Andrus
I have only remote access to Windows 2003  server.
Postgres 8.1.3 .msi files refuses to install Postgres server even when I run 
in console session using
mstsc /console

So I installed Postgres 8.1.3 binaries from a zip file and PgAdmin latest 
binaries from pgadmin.org

Now PgAdmin guru suggests that I should install server management 
instrumentarium but gives no help how to install.

How to install server management instrumentarium without compiling in 
Windows 2003 server ?

Andrus. 



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [pgadmin-support] How install server management instrumentarium without compiling

2006-04-04 Thread Dave Page

-Original Message-
From: "Andrus"<[EMAIL PROTECTED]>
Sent: 04/04/06 19:58:53
To: "pgadmin-support@postgresql.org"
Subject: [pgadmin-support] How install server management instrumentarium 
without compiling


> Now PgAdmin guru suggests that I should install server management 
> instrumentarium but gives no help how to install.
> How to install server management instrumentarium without compiling in 
> Windows 2003 server ?

Copy the dll into the server's lib directory (if you haven't done so already), 
then in the maintenance db that pgAdmin initially connects to, run the 
admin81.sql script. You'll need to get that from the adminpack download on the 
website in which it's called admin81.sql.in. You might need to check any paths 
in it first.

Regards, Dave

-Unmodified Original Message-
I have only remote access to Windows 2003  server.
Postgres 8.1.3 .msi files refuses to install Postgres server even when I run 
in console session using
mstsc /console

So I installed Postgres 8.1.3 binaries from a zip file and PgAdmin latest 
binaries from pgadmin.org

Now PgAdmin guru suggests that I should install server management 
instrumentarium but gives no help how to install.

How to install server management instrumentarium without compiling in 
Windows 2003 server ?

Andrus. 



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[pgadmin-support] How to see relation names

2006-04-04 Thread Andrus
Relation column in Locks page of  PgAdmin III Server Status Window shows
only relation number.

How to see relation names instead of relation numbers in this column ?
Is'nt it more reasonable to show names in pgAdmin ?

Andrus.




---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[pgadmin-support] silently fails to connect to remote server

2006-04-04 Thread Chris Velevitch
I'm using the Windows version 1.4.2 on Win XP Sp1.

When I try to connect to a remote server, the connection silently
fails. According to the manual, I should be getting a pop-up dialog
detailing the connection failure. Instead, the status bar at the
bottom of the window shows:-

  Connecting to database... Failed

Also the log shows nothing.


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[pgadmin-support] Maintenance DB

2006-04-04 Thread Chris Velevitch
I'm using Windows version 1.4.2 on Win XP Sp1.

I'm trying to add a new server for a remote server and I don't
understand what the 'Maintenance DB' attribute is. Manual says nothing
about it.


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [pgadmin-support] silently fails to connect to remote server

2006-04-04 Thread Chris Velevitch
My connection is failing because port 5432 on our firewall was not
open to outgoing connections. This situation should be detectable and
as such should be logged and reported to the user.

On 4/5/06, Chris Velevitch <[EMAIL PROTECTED]> wrote:
> I'm using the Windows version 1.4.2 on Win XP Sp1.
>
> When I try to connect to a remote server, the connection silently
> fails. According to the manual, I should be getting a pop-up dialog
> detailing the connection failure. Instead, the status bar at the
> bottom of the window shows:-
>
>   Connecting to database... Failed
>
> Also the log shows nothing.
>
>
> Chris
> --
> Chris Velevitch
> Manager - Sydney Flash Platform Developers Group
> www.flashdev.org.au
>


--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly