Dear Vishal,Ashish,
Good Morning... Today morning i seen three mails from your side.. all the mails
are affected in spam virus... so I can't get that mails.. Kindly send mails
again
Thanks & Regards
Jayakumar M
From: Vishal Arora [mailto:[EMAIL PROTECT
From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>,"Vishal
Arora" <[EMAIL PROTECTED]>,
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 19:23:20 +0530
Dear Vishal / Ashish
I did these steps only...
1. I
> Well, sending it to me will do you zero good, as my C skills are
> awful. Assuming it's a reasonable size, I think the list will take
> it.
No the complete example need also db schema and data.
I try to reproduce with a small program.
>
>
>
>>> There is nothing in the cache that isn't "in
> This is also opaque to me now, because that doesn't seem to be what
> your example said. Perhaps you should post your function body?
>
Yes, but maybe the post are too big, can I send it to your address ?
It's written in C
> There is nothing in the cache that isn't "in the database", as it
>
On Mon, Jul 16, 2007 at 10:22:33PM +0200, De Leeuw Guy wrote:
> >
> Yes, but maybe the post are too big, can I send it to your address ?
> It's written in C
Well, sending it to me will do you zero good, as my C skills are
awful. Assuming it's a reasonable size, I think the list will take
it.
--- Mark Steben <[EMAIL PROTECTED]> wrote:
> select 45198705,false,id,next_avail_senddate(id,date(send_date)) from
> (select
> id,timeclause_combine(date(estmileage_timeclause(service_date,mileage,last_s
> ervice_date,last_mileage,
>date_of_purchase,year_purchased,10750,cid,serindex_date,id
, Hi, I'm trying to index on a coalesce function:
The index definition is CREATE INDEX emailrcpts_cid_coalesce_dtofpurch"
btree (cid, (COALESCE(date_of_purchase, '1900-01-01'::date)))
A portion of the query I am trying to optimize follows:
select 45198705,false,id,next_avail_senddate(i
On Mon, Jul 16, 2007 at 07:47:09PM +0200, De Leeuw Guy wrote:
> >
> > So if I am reading you correctly, IF code IN (1,2) THEN {do
> > something}? What do you do then? I don't get this part.
> >
> I record a row with code = 3 and the value = the sum of each values in
> code 1 & 2
This is al
Hello Andrew,
Thanks for your attention
Andrew Sullivan a écrit :
> I tried to answer the previous version of this mail, but I don't
> understand it. Let me see if my questions trigger something for you,
> though.
>
> So if I am reading you correctly, IF code IN (1,2) THEN {do
> something}?
I tried to answer the previous version of this mail, but I don't
understand it. Let me see if my questions trigger something for you,
though.
On Mon, Jul 16, 2007 at 12:32:07PM +0200, De Leeuw Guy wrote:
>
> a table :
> CREATE TABLE test (
> codeint8 NOT NULL,
> qte
Hello all
I encoured a problem with specific kind of commands
a table :
CREATE TABLE test (
codeint8 NOT NULL,
qte float8,
CONSTRAINT test_pkey PRIMARY KEY (code)
)
CREATE TRIGGER trig_update_sum BEFORE INSERT OR UPDATE OR DELETE ON
table_test
FOR EACH ROW
Hello all
I encoured a problem with specific kind of commands
a table :
CREATE TABLE test (
codeint8 NOT NULL,
qte float8,
CONSTRAINT test_pkey PRIMARY KEY (code)
)
CREATE TRIGGER trig_update_sum BEFORE INSERT OR UPDATE OR DELETE ON
table_test
FOR EACH ROW
Hi,
I'm having this problem on Windows 2003-SP1, with Postgresql 8.2.
At a certain moment (after several hours of use, randomly), the postgresql
server stops responding. When checking in the log, I see this message
repeatedly :
Could not send data to client: Unknown winsock error 10055
The prob
Dear Vishal / Ashish
I did these steps only...
1. I get the pgAgent.sql script in pgAdmin III directory , I copied that
scripts and execute the scripts in my default postgres database.
2. After, I get the jobs icon in our postgres.
3. In that jobs icon I given jobs name,schedule name
From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Vishal Arora" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>,
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 17:21:58 +0530
Dear Vishal/Ashish,
Sorry to say that... Kindly give me the steps in widows format p
Dear Vishal/Ashish
In my pgpass.conf file there is two password is there.. both the passwords are
same
Host PortDatabaseUserNamePassword
localhost: 5432: postgres: postgres:satyam123$
localhost: 5432:*: postgres:satyam123$
Thanks
Your service is not starting, check you have given proper password while
installing pgAgent service.
the password should be OS password for postgres user and not the database
user password
- Original Message -
From: "Vishal Arora" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PR
Dear Vishal/Ashish,
Sorry to say that... Kindly give me the steps in widows format please...
I done as per your steps only..
1. step i done it .. Its ran fine..
2. step also i done it. ( I replace the path of pgAgent from C:\Program
Files\Postgresql to D:\Program Files),
3. Login using Pos
Dear Vishal and Ashish,
In pgpass.config file i have two login and two passwords..both the password was
same.. shall remove one password..
I think i installed pgAgent is wrong ... I disabled the pgAgent service.. Now i
am removing that pgAgent and trying to reintall it...
Thanks & Regards
J
Hi Jayakumar,
PgAgent for windows
1) Run PgAgent.sql script in maintenance database (Postgres database by
default).
2) Install PgAgent service using the following command on command prompt -
C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u postgres
-p hostaddr=127
Dear Vishal,
Sorry ... I didn't recvd any mails from you and Ashish...Kindly send me again..
Thanks & Regards
Jayakumar M
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Mon 7/16/2007 12:27 PM
To: Jayakumar_Mukundaraju; [EMAIL PROTECTED]
Subject: RE: [A
21 matches
Mail list logo
