469,133 Members | 1,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

pg_dump, pg_restore

1
pg_dump remove name of schema from default value.
i don't know why. how can i solve this problem ?

For example:
BEFORE PG_DUMP:

CREATE TABLE "is8"."tb_kotuce" (
"id_kotuc" CHAR(10) DEFAULT is8.fn_sq_id_kotuc() NOT NULL,
...
...

AFTER PG_RESTORE

CREATE TABLE "is8"."tb_kotuce" (
"id_kotuc" CHAR(10) DEFAULT fn_sq_id_kotuc() NOT NULL,
...
...

SCHEMA NAME is8 IS REMOVED AFTER PG_RESTORE.

AFTER INSERT ROW TO TABLE is8.tb_kotuce, ERROR OCCURRED, BECAUSE NAME OF SCHEMA IS MISSING IN FRONT OF FUNCTION NAME 'fn_sq_id_kotuc()'.

I NEED RESTORE WITH NAME OF SCHEMA.
Feb 11 '08 #1
0 1975

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Sam | last post: by
7 posts views Thread by Howard Lowndes | last post: by
1 post views Thread by Ruth Hsieh | last post: by
6 posts views Thread by Michal Hlavac | last post: by
reply views Thread by Otto Blomqvist | last post: by
1 post views Thread by Neil Zanella | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.