pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)  latest in thread

Message-ID: <fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com>
Permalink:  ../fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com/
Also on:    postgresql.org/message-id/fe27bfd40711050732i390b41c5x5bc3a5f300422338@mail.gmail.com

 · 

reply

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