Re: pg_dump, pg_restore. - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump, pg_restore.
Date
Msg-id 251.1202961811@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump, pg_restore.  ("Emil J." <EmilJ@pyton.sk>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Emil J."
Date:
Subject: pg_dump, pg_restore.
Next
From: "Sergey Konoplev"
Date:
Subject: Re: Conditional ordering operators