Re: pg_dump, pg_restore.

"Emil J." <EmilJ@pyton.sk> writes:
> Before pg_dump, default value is:   ... DEFAULT moja_schema.fn_sq_id_kotuc() ...
> After pg_restore, default value is:   ... DEFAULT fn_sq_id_kotuc() ...
> The name of the scheme is missing, it is cut off.

> I need first variant of default value (with name of the schema), because second variant raise exception if I insert
twoor more records. 

No, you don't need that.  The two versions you claim are different are
in fact exactly the same thing.  Please show us the actual problem
you're having, not an uninformed guess as to the cause.

            regards, tom lane