Re: [pgadmin-support] Extremely slow queries in pgAdminIII

2005-03-18 Thread Asger Petersen
Hi Dave, thanks for your answer. No, all the machines are set to 'Errors only'. It is a bit of a mystery to me and I'm beginning to really wonder what makes one machine that much faster than the others. Thinking of it the slow machines all have a clean install of pgAdmin and no other postgreSQL r

Re: [pgadmin-support] Extremely slow queries in pgAdminIII

2005-03-18 Thread Dave Page
> -Original Message- > From: Asger Petersen [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 17:34 > To: Dave Page; pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] Extremely slow queries in pgAdminIII > > Hi Dave, thanks for your answer. Drat - I don't ever remember it

Re: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

2005-03-18 Thread Laurent Birckel
Thanks for your answer.       a validator seems to be set (plpgsql_validator)     and the validator function exists     ( CREATE OR REPLACE FUNCTION plpgsql_validator( oid) RETURNS void AS'$libdir/plpgsql', 'plpgsql_validator'LANGUAGE 'c' VOLATILE;     )       I also tried to cal

Re: [pgadmin-support] No way to have error message on pgadmin III pg 8.0

2005-03-18 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laurent BirckelSent: 18 March 2005 16:51To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] No way to have error message on pgadmin III pg 8.0 where working on pgadminIII to writing a function

[pgadmin-support] No way to have error message on pgadmin III pg 8.0

2005-03-18 Thread Laurent Birckel
where working on pgadminIII to writing a function (on windows, postgre 8.0) if I fortget a ";" or a ")" (for all other errors toot, I get absolutely nothing when I run the crate or alter function (F5) I just know that there is an error because I don't have the message "query exucuted ...",

[pgadmin-support] Extremely slow queries in pgAdminIII

2005-03-18 Thread Asger Petersen
Hi list We are using pgAdminIII to access a postgresql 8.0.0 rc2 on a win2k machine. The problem is, that performance of queries done with pgAdmin varies extremely between clients. For instance we have two winXp machines w. pgAdminIII v. 1.2.0. Executing a simple 'SELECT * FROM sometable' w. 4000

Re: [pgadmin-support] Extremely slow queries in pgAdminIII

2005-03-18 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Asger Petersen > Sent: 18 March 2005 14:37 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Extremely slow queries in pgAdminIII > > Hi list > > We are using pgAdminIII to acces