Hi,
In my schema : "my" I create sql function
CREATE OR REPLACE FUNCTION my.my_foo(int4) RETURNS varchar AS '
select k.k_dupa ||coalesce( '' ['' || k.k_number || '']'' ,'''')
from kont k
where k_id = $1;
' LANGUAGE 'sql';
table kont is in schema public.
Everythink working ok, but when I try to restore backup system write :
pg_restore: [archiver (db)] could not execute query: ERROR: Relation "kont" does not exist
pg_restore: *** aborted because of error
Marek Wróbel
