Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-08 Thread Andreas Pflug
Ian Freislich wrote:

Beigin new to this list, is there a place where I could suggest
functionality (I have one nice to have request on low priority for
the developers which would make pgAdmin a TOAD equivalent for
PostgreSQL for us)?
 

Yes,
just post things like that on pgadmin-hackers.
Regards,
Andreas


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


Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-08 Thread Andreas Pflug
Michael Shapiro wrote:

Actually it isn't random, but the sort order might not be what you 
expect. It looks like (regard as meta code)
ORDER BY isdomain, isArray, typname
   

This doens't mean anything to me. What I am after is to not have to
scroll up and down searching for the type. If there is no order by clause
that will suffice, 

There *is* an ordering clause, look at that pseudo code above.

then you could add code in PgAdmin itself to do
the ordering. What I think would be a good order is
	builtin types first
	user defined types next
	schema table types next (ordered by schema)
alphabetic within each group. Does that make sense?
 

Michael,

please don't send private mail. Everything should be discussed publicly; 
we're Open Source. Besides, private mail screws up my inbox processing; 
your answers might well go unnoticed to spam.

As I said we'll be refactoring types handling. You might find find the 
current ordering not helpful, others might do so (at least I like 
domains first, because I use domains to abstract from real database 
types, increasing portability)

Regards,
Andreas


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


[pgadmin-support] Some questions

2003-12-08 Thread Jyrki Wahlstedt
Hi,
I have been trying to build pgAdmin3 in two OSs. Both have failed, 
however. One, Mac OS X, is nothing to wonder, because it is explicitly 
said that the port is experimental. The other, however, is FreeBSD 5.1. 
There wxwindows is not building, after downloading and configuring make 
fails because no input files are specified. The binary package would 
probably be ok, but the library dependencies are strict and I have 
newer packages than required and I do not want to build old packages 
just to make this program run (other packages want the later ones!).
Has anyone anywhere seen anything like this?
!
! Jyrki Wahlstedt
! Viialankatu 15 as 8mob. +358-40-502 0164
! FI-32700 Huittinen
!
! Our life is no dream; but it ought to become one and perhaps will.

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


Re: [pgadmin-support] Some questions

2003-12-08 Thread Andreas Pflug
Jyrki Wahlstedt wrote:

Hi,
I have been trying to build pgAdmin3 in two OSs. Both have failed, 
however. One, Mac OS X, is nothing to wonder, because it is explicitly 
said that the port is experimental. The other, however, is FreeBSD 
5.1. There wxwindows is not building, after downloading and 
configuring make fails because no input files are specified. The 
binary package would probably be ok, but the library dependencies are 
strict and I have newer packages than required 
Maybe you simply can create the missing libraries by creating symlinks 
to the existing ones?

You'll need to give more details about what's failing. Are you using our 
wx snapshot?

Regards,
Andreas


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [pgadmin-support] Some questions

2003-12-08 Thread Jyrki Wahlstedt
Hi,
I downloaded wxWindows-pgAdmin3-20031010-7.tar.bz2. But I just noticed 
that if I invoke gmake, I'll get the compilation running. So I had a 
version of make not understanding the Makefile built:-( For the time 
being I am satisfied, the error was mine (though it could be good to 
make sure to use gmake if it exists?).
!
! Jyrki Wahlstedt
! Viialankatu 15 as 8mob. +358-40-502 0164
! FI-32700 Huittinen
!
! Our life is no dream; but it ought to become one and perhaps will.

On 8.12.2003, at 12:41, Andreas Pflug wrote:

You'll need to give more details about what's failing. Are you using 
our wx snapshot?


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [pgadmin-support] Some questions

2003-12-08 Thread Andreas Pflug
Jyrki Wahlstedt wrote:

Hi,
I downloaded wxWindows-pgAdmin3-20031010-7.tar.bz2. But I just noticed 
that if I invoke gmake, I'll get the compilation running. So I had a 
version of make not understanding the Makefile built:-( For the time 
being I am satisfied, the error was mine (though it could be good to 
make sure to use gmake if it exists?).
I don't quite understand what you did, did you run ./configure 
appropriately before making?

Regards,
Andreas
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-support] Some questions

2003-12-08 Thread Dave Page
 

> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
> Sent: 08 December 2003 12:03
> To: Jyrki Wahlstedt
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Some questions
> 
> Jyrki Wahlstedt wrote:
> 
> > Hi,
> > I downloaded wxWindows-pgAdmin3-20031010-7.tar.bz2. But I 
> just noticed 
> > that if I invoke gmake, I'll get the compilation running. 
> So I had a 
> > version of make not understanding the Makefile built:-( For 
> the time 
> > being I am satisfied, the error was mine (though it could 
> be good to 
> > make sure to use gmake if it exists?).
> 
> I don't quite understand what you did, did you run 
> ./configure appropriately before making?

Make doesn't work on FreeBSD (for wx anyway) - you must use gmake.

Regards, Dave.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-support] Some questions

2003-12-08 Thread Jyrki Wahlstedt
Definitely,
according to the documentation (CC to use the latest compiler):
./configure --with-gtk --enable-gtk2 --enable-unicode --disable-shared 
--enable-debug CC=gcc33 CXX=g++33
After this 'make' leads to error, gmake starts compiling…
PS I read Dave's message while writing this, so it seems the 
documentation should be updated!?
!
! Jyrki Wahlstedt
! Viialankatu 15 as 8mob. +358-40-502 0164
! FI-32700 Huittinen
!
! Our life is no dream; but it ought to become one and perhaps will.

On 8.12.2003, at 14:02, Andreas Pflug wrote:

Jyrki Wahlstedt wrote:

Hi,
I downloaded wxWindows-pgAdmin3-20031010-7.tar.bz2. But I just 
noticed that if I invoke gmake, I'll get the compilation running. So 
I had a version of make not understanding the Makefile built:-( For 
the time being I am satisfied, the error was mine (though it could be 
good to make sure to use gmake if it exists?).
I don't quite understand what you did, did you run ./configure 
appropriately before making?

Regards,
Andreas


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


Re: [pgadmin-support] feature not welcome in query

2003-12-08 Thread Dave Page



Hi Vitor,
 
Please use the support list ([EMAIL PROTECTED]) 
for future problems rather than private email.
 
I have fixed this bug in CVS - thanks for the 
report.
 
Regards, Dave,

  
  
  From: Vitor [mailto:[EMAIL PROTECTED] 
  Sent: 08 December 2003 01:48To: Dave 
  PageSubject: feature not welcome in query
  
  Sorry if you know about or disagree my 
  comments.
   
  In "Query", you:
  - open a file;
  - update this file (dont save);
  - choice open another file.
   
  pgAdmin III - Version 1.0.2 (Nov 28 
  2003)
   
  open the file required and lost the updated 
  actual file.
   
  Vitor