[pgadmin-support] query tool save problem

2006-04-20 Thread Jan Zach
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
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

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
> -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