Strange behavior after refreshing stored functions - Mailing list pgsql-admin

From Együd Csaba
Subject Strange behavior after refreshing stored functions
Date
Msg-id 003301c3ad18$233e4650$230a0a0a@compaq
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: pg_restore and FK constraints with large dbs
Next
From: Andrew Sullivan
Date:
Subject: Re: compare two databases