"A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx> 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 fail in *many* situations not only pg_dump. A check constraint is only expected to examine the current row of its table. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general