Hi everybody,
when saving some national chars (see e.g. char with code 248 in table
http://biega.com/ISO-8859-2.gif) everything seems ok but the result file on the
disk is of size 0.
I'm running version 1.4.1 (Feb 11 2006) build from ports on FreeBSD
6.0-RELEASE-p3, widgets wxgtk2u-2.6.
Regar
Title: RE: pgAgent question
From: Benjamin Krajmalnik
[mailto:[EMAIL PROTECTED] Sent: 20 April 2006 20:50To:
Dave Page; pgadmin-support@postgresql.orgSubject: RE:
[pgadmin-support] pgAgent question
It
takes about the same time.
Since I do not need statistics on ever
Title: RE: pgAgent question
It
takes about the same time.
Since
I do not need statistics on every single test (some of them have data that is
not suited for statistical analysis), I modified my schema
slightly.
Each
test which has to be processed for statistics is tagged as such, reducing t
Title: RE: pgAgent question
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Benjamin
KrajmalnikSent: 20 April 2006 17:53To:
pgadmin-support@postgresql.orgSubject: Re: [pgadmin-support]
pgAgent question
The job has a single
execution step:
se
Title: RE: pgAgent question
The job has a single
execution step:
select * from fn_calcstats2();
The function code follows:
CREATE OR REPLACE FUNCTION fn_calcstats2() RETURNS
"timestamp" AS$BODY$DECLARE startdate
timestamp; myrecord Record; myrecord2
Record; mycursor refcurs
Title: RE: pgAgent question
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Benjamin
KrajmalnikSent: 20 April 2006 15:02To:
pgadmin-support@postgresql.orgCc: Dave PageSubject: Re:
[pgadmin-support] pgAgent question
Yes.
PgAdmin/pgAgent and PostgreS
Title: RE: pgAgent question
Yes.
PgAdmin/pgAgent and PostgreSQL ar running
on the same box.
RUnning the stored procedure even from a
remote pgAdmin at the console results in the same 16 second
performance.
From: Dave Page
[mailto:[EMAIL PROTECTED]Sent: Thu 4/20/2006 1:17
AMTo: Benjam
> -Original Message-
> From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED]
> Sent: 19 April 2006 20:23
> To: Dave Page
> Subject: pgAgent question
>
> Hi Dave,
>
> I have a quick question.
> I have a stored procedure which we use to calculate
> statistics against each test for the pa