pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase connections and stored procs (functions)
2+ messages / 2 participants
[nested] [flat]
* Database connections and stored procs (functions)
@ 2007-11-05 15:32 Radhika S <radhika.sambamurti@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Radhika S @ 2007-11-05 15:32 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Database connections and stored procs (functions)
@ 2007-11-06 02:47 Merlin Moncure <mmoncure@gmail.com>
parent: Radhika S <radhika.sambamurti@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Merlin Moncure @ 2007-11-06 02:47 UTC (permalink / raw)
To: Radhika S <radhika.sambamurti@gmail.com>; +Cc: pgsql-performance
On 11/5/07, Radhika S <radhika.sambamurti@gmail.com> wrote:
> 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?
the answer to your question probably lies within the log. make sure
your daemon is logging the connection attempt and any errors. Check
the database log for any problems. My gut is telling me the problem
might be on your end (can't be sure with this info).
merlin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-06 02:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-05 15:32 Database connections and stored procs (functions) Radhika S <radhika.sambamurti@gmail.com>
2007-11-06 02:47 ` Merlin Moncure <mmoncure@gmail.com>
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