Hello!
I'm running pgadmin 1.4.2 and i came over a problem, if i got two schemas and two tables with the same name under them eg:

schemas(2)
-list
   -pc_752
-wip
   -pc_752

Then i do a custom backup of list / pc_752.

The problem is when i rightclick > restore list / pc_752 it will try to restore the data in wip / pc_752, even if this wasn't the target-table.

I discovered this problem when i ran a "sql" "only data" "insert" backup, and viewed the header of the backedup data that said:

-- Name: pc_752_id_seq; Type: SEQUENCE SET; Schema: wip; Owner: postgres

that's not right because the backup was from "list" not "wip".

Best Regards

Andreas Jonsson!


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to