[pgadmin-support] Why pgAgent need pgAdmin ?

2007-03-22 Thread Ezequias R. da Rocha
Hi list, I am having many trouble to install pgAgent on my Red Hat but there is so many dependencies because we need to install pgAdmin and his dependencies. I don't understand why to run pgAgent we must install pgAdmin (an User Interface on a server). Our application depends it to be comple

Re: [pgadmin-support] Why pgAgent need pgAdmin ?

2007-03-22 Thread Dave Page
Ezequias R. da Rocha wrote: > Hi list, > > I am having many trouble to install pgAgent on my Red Hat but there is > so many dependencies because we need to install pgAdmin and his > dependencies. I don't understand why to run pgAgent we must install > pgAdmin (an User Interface on a server). You

[pgadmin-support] Timer on Query Editor

2007-03-22 Thread Ezequias R. da Rocha
Hi list, I would like to recommend a timer (to execute the query statement with intervals of seconds ). -- Atenciosamente Ezequias Rodrigues da Rocha ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at

Re: [pgadmin-support] Timer on Query Editor

2007-03-22 Thread Dave Page
Ezequias R. da Rocha wrote: > Hi list, > > I would like to recommend a timer (to execute the query statement with > intervals of seconds ). There already is one in the status bar. Regards, Dave ---(end of broadcast)--- TIP 2: Don't 'kill -9' the

[pgadmin-support] Suggestion Queries

2007-03-22 Thread Ezequias R. da Rocha
Hi list, Would be great if pgAdmin could report the current query of the database in the Server Status (in a new tab) A little help could be here: select current_query from pg_stat_activity; or (more completely) select * from pg_stat_activity; -- Atenciosamente Ezequias Rodrigues da Rocha

Re: [pgadmin-support] Suggestion Queries

2007-03-22 Thread Dave Page
Ezequias R. da Rocha wrote: > Hi list, > > Would be great if pgAdmin could report the current query of the database > in the Server Status (in a new tab) > > A little help could be here: > > select current_query from pg_stat_activity; > > or (more completely) > > select * from pg_stat_activity

Re: [pgadmin-support] Timer on Query Editor

2007-03-22 Thread Ezequias R. da Rocha
I saw it now. Thank you. but a doubt: why call it lock ? Sorry my dummy question. Ezequias Dave Page escreveu: Ezequias R. da Rocha wrote: Hi list, I would like to recommend a timer (to execute the query statement with intervals of seconds ). There already is one in the status bar

Re: [pgadmin-support] Timer on Query Editor

2007-03-22 Thread Dave Page
Ezequias R. da Rocha wrote: > I saw it now. Thank you. > > but a doubt: why call it lock ? Sorry my dummy question. Where is it called a lock? Regards, Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http:/

Re: [pgadmin-support] Timer on Query Editor

2007-03-22 Thread Ezequias R. da Rocha
Tools > Server Status (Pane Locks) Ezequias Dave Page escreveu: Ezequias R. da Rocha wrote: I saw it now. Thank you. but a doubt: why call it lock ? Sorry my dummy question. Where is it called a lock? Regards, Dave -- Atenciosamente Ezequias Rodrigues da Rocha

Re: [pgadmin-support] Timer on Query Editor

2007-03-22 Thread Dave Page
You are mixing up your own questions - this is the thread about the timer! The reason that pane is called Locks is because those are what it displays. You probably want the Status tab which shows the query on each connection. The Locks tab shows each lock and the query (and other info) that cause