Re: function cache??

Janning Vygen wrote:
> Am Freitag, 29. Juni 2001 16:53 schrieb Tom Lane:
> > Janning Vygen  writes:
> > > it seems to me that function are not reloaded vene if id rop them and
> > > recreate them.
> >
> > That's hard to believe.  Example please?
> >
> >            regards, tom lane
>
>
> small webpage is grabbing some contactdata.
> i have a shell script which drops and recreates datatbase
> and the cat the following with
>
> cat sql_commands | psql kontaktdaten
>
> last thing i added was the telephone check
> and it seems that the backend just dont care about it.
>
> but i do believe that i did a mistake anywhere else, os i go and search for
> it.
>
> >>> file sql_commands
> [...]

    It's  even  harder  to  believe  that a user defined function
    survives a database drop/recreate. What database version  are
    you using?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com