Strange behavior after refreshing stored functions

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "pgsql-admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Strange behavior after refreshing stored functions
Date: 2003-11-17 14:36:07
Message-ID: 003301c3ad18$233e4650$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
I have a very annoying problem at one of my customers.

The phenomenon is the following:
I run all function refresh scripts (create or replace function exrpssions)
and trying to use them.
Sometimes it seems nothing has happend to the database and the functions.
They work just the same way as before. The only way to have them work is to
dump out all the database, drop the database, recreate the database and
restore the whole thing - the same dump file. After this it works as fine as
I except.

What can be the problem with it? I do not like to go on site for every
program refresh to dump out and back the whole database. There must be a
better solution.

(system: postgres 7.3.2 on RH7.1)

Thank you for your help.

Best Regards,
-- Csaba

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-11-17 16:51:46 Re: compare two databases
Previous Message Cris Carampa 2003-11-17 10:53:47 using vacuumdb in crontab