From: Radhika S <radhika.sambamurti@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Database connections and stored procs (functions)
Date: Mon, 5 Nov 2007 10:32:46 -0500
Message-ID: <fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com> (raw)
Hi,
I am running postgres 8.2 on RH linux.
My daemon downloads files and then inserts the data into preliminary
tables, and finally calls a stored procedure which reads data from a
view and inserts into the final table.
I have a bit of a peculiar problem. (I understand this may not be the
right venue).
My deamon calls a stored procedure SP_LoadFiles().
The daemon stops syncing at about 6:30 pm and restarts syncing at about 7:30 am.
Every day, I have to manually re-start the daemon for the function
sp_LoadFiles() to actually load the files.
I can see that the procedure is being called, but it does not load the data.
If I run the procedure manually via psql : select * from
sp_loadfiles(); it works and the data is loaded.
my stored proc sp_loadfiles is accessing a View which is accessing a
couple of tables. There is no dynamic sql being generated, just
inserts from the view.
Is this a connection issue?
Do I have to end the daemons db connection. Is this set in the postgresql.conf?
Thank you.
Radhika
--
It is all a matter of perspective. You choose your view by choosing
where to stand. --Larry Wall
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: radhika.sambamurti@gmail.com
Subject: Re: Database connections and stored procs (functions)
In-Reply-To: <fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com>
References: <fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox