Re: [GENERAL] pg_dump and check-constraints

2009-10-01 Thread Tom Lane
"A. Kretschmer" writes: > test=# create function check_b() returns bool as $$ declare s int; begin > select into s sum(i) from b; if s > 3 then return true; else return false; > end if; end;$$ language plpgsql; > test=*# create table a (i int check(check_b())); This is unsupported, and will fa

[GENERAL] pg_dump and check-constraints

2009-10-01 Thread A. Kretschmer
Hi, For instance, i have such a database: (it is just a silly example) test=# create function check_b() returns bool as $$ declare s int; begin select into s sum(i) from b; if s > 3 then return true; else return false; end if; end;$$ language plpgsql;