| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Emil J(dot)" <EmilJ(at)pyton(dot)sk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump, pg_restore. |
| Date: | 2008-02-14 04:03:31 |
| Message-ID: | 251.1202961811@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Emil J." <EmilJ(at)pyton(dot)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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2008-02-14 06:48:40 | Re: Conditional ordering operators |
| Previous Message | Dan Armbrust | 2008-02-14 02:06:55 | performance issues on windows with 8.3.0? |