On 17/1/06 18:49, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a FC4 server running PostgreSQL 8.1.0 with no apparent problems.
> I compiled from source and so far have experienced only minor issues
> related to dumping databases from 7.4.6 and trying to get them working
> o
Hi,
I have a FC4 server running PostgreSQL 8.1.0 with no apparent problems.
I compiled from source and so far have experienced only minor issues
related to dumping databases from 7.4.6 and trying to get them working
on 8.1.0. My set returning functions were mangled and needed to be rebuilt.
Thanks to the assistance of Mr. Page my troubles have been solved
Adding -l 2 switch the event log showed that there was issue with the
pgAgent INSTALL command.
I was omitting at the end of the command "password=secrete"
After REMOVE and INSTALL with the corrected string All is Well
"pgAgent IN
> -Original Message-
> From: Hogan, James F. Jr. [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2006 15:37
> To: Dave Page
> Subject: RE: [pgadmin-support] pgagent jobs never start
>
> Wow that was a world of help adding the -l 2 switch...
Great, glad to hear it's working.)
> I will po
> -Original Message-
> From: Rikard Pavelic [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2006 10:40
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] procedure properties problem
>
> If I omit the 'returns setof varchar' I will get only one
> result
Dave Page wrote:
The function written above will never work as you have a mismatch of
parameter and return types, but in answer to your query, the PostgreSQL
docs say:
"When there are OUT or INOUT parameters, the RETURNS clause may be
omitted."
(http://www.postgresql.org/docs/8.1/interactive/sq
> -Original Message-
> From: Hogan, James F. Jr. [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2006 17:41
> To: Dave Page
> Subject: RE: [pgadmin-support] pgagent jobs never start
>
> I did in fact have two separate databases one named
> "postgres" the other
> named "hogan"
>
> I was
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Rikard Pavelic
> Sent: 16 January 2006 15:02
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] procedure properties problem
>
> Hi!
> I don't know if this is missing feature or bu
