Brian Kalbfus wrote:
>
> The SQL will return a row if the jobhostagent field matches every time
> (the OR clause is on the same level as all the AND clauses). We need to
> group the last two clauses:
Thanks Brian, I've applied a patch per your suggestion.
Regards, Dave.
Jean-Max Reymond wrote:
> I have installed the Windows version of PostgreSql 8.2 and
> unfortunately, the data repertory was not correct. So, uninstall and
> install again with the correct path. I try to connect to the base with
> psql and all is correct but pgadmin3 1.8 loops and I have to killed
Jean-Max Reymond wrote:
> Hi,
> when I create a role with pgadmin3, variables (like search_path) are not
> enabled in the select menu. I have to create the role and then all the
> variables are allowed. Is this behavior a normal way ?
That was changed for 1.8.0:
2007-09-24 DP 1.8.0 Allow GUCs t
Jean-Max Reymond wrote:
> Hi,
> when I create a rule with pgadmin3, variables (like search_path) are not
> enabled in the select menu. I have to create the rule and then all the
> variables are allowed. Is this behavior a normal way ?
Rules don't have variables - they're not even on the dialogue.
I have two jobs scheduled and the second one ran every poll interval,
regardless of any schedule I put in it. I traced the cause to the "host
agent" field being populated.
Looking at the source of pgAgent.cpp, from 5 weeks ago, I see the
following query being used to check if the agent should
Hi,
when I create a rule with pgadmin3, variables (like search_path) are not
enabled in the select menu. I have to create the rule and then all the
variables are allowed. Is this behavior a normal way ?
---(end of broadcast)---
TIP 4: Have you searc
I have installed the Windows version of PostgreSql 8.2 and
unfortunately, the data repertory was not correct. So, uninstall and
install again with the correct path. I try to connect to the base with
psql and all is correct but pgadmin3 1.8 loops and I have to killed the
process. It seems that pgad
I have installed the Windows version of PostgreSql 8.2 and
unfortunately, the data repertory was not correct. So, uninstall and
install again with the correct path. I try to connect to the base with
psql and all is correct but pgadmin3 1.8 loops and I have to killed the
process. It seems that p
Hi,
when I create a role with pgadmin3, variables (like search_path) are not
enabled in the select menu. I have to create the role and then all the
variables are allowed. Is this behavior a normal way ?
---(end of broadcast)---
TIP 1: if posting/
