"Emil J." <EmilJ@xxxxxxxx> 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 two or 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq