Strange behavior after refreshing stored functions

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема Strange behavior after refreshing stored functions
Дата
Msg-id 003301c3ad18$233e4650$230a0a0a@compaq
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rudi Starcevic
Дата:
Сообщение: Re: pg_restore and FK constraints with large dbs
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: compare two databases