Janning Vygen wrote:
> Am Freitag, 29. Juni 2001 16:53 schrieb Tom Lane:
> > Janning Vygen <vygen@planwerk6.de> 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