Re: Dependence beetwen Function - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Dependence beetwen Function
Date
Msg-id 010401c1ca70$cacec160$d28efea9@GMENDOLA2
Whole thread Raw
In response to Re: Dependence beetwen Function  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
"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");




pgsql-admin by date:

Previous
From: Radu-Adrian Popescu
Date:
Subject: Re: client connection
Next
From: Jean-Michel POURE
Date:
Subject: Re: Dependence beetwen Function