Re: Dependence beetwen Function

"Stephan Szabo" <sszabo@megazone23.bigpanda.com> wrote:
> On Tue, 12 Mar 2002, Gaetano Mendola wrote:
>
> > Hi to all
> >
> > Suppose that I have the function A that use the fucntion B.
> > When I drop and reconstruct B I should also reconstruct A.
> > Can I avoid this ?
> > Is a really problem with hundreds of function around.
>
> If you're using 7.2 you can use create or replace function
> rather than drop function followed by create function.
>
Fine. Yesterday with the release 7.1.3 I notice that if a table have a
constraint like this:


CREATE TABLE user_data (
.......
login VARCHAR(64) NOT NULL CHECK ( myFunction(login) ),
......
);

if I drop and recreate the function myFunction
I'm not able to insert data on table user_data.
May be with the version 7.2 this problem not exist anymore
(with the replace feature) but I notice also that if I do a

pg_dump > dump.sql

I have on dump.sql before the creation of tables and after the
creation of functions, in this way the table user_data is not
created ... :-(



I hope that this was fixed in version 7.2

Ciao
Gaetano

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");