From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Janning Vygen <vygen(at)planwerk6(dot)de> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: function cache?? |
Date: | 2001-06-29 15:54:22 |
Message-ID: | 200106291554.f5TFsMw03715@jupiter.us.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Janning Vygen wrote:
> Am Freitag, 29. Juni 2001 16:53 schrieb Tom Lane:
> > Janning Vygen <vygen(at)planwerk6(dot)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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas T. Veldhouse | 2001-06-29 15:58:11 | Re: |
Previous Message | Michael | 2001-06-29 15:52:53 | Re: Re: useability of apache, PHP,Postgres for real business apps |