Thread: 1.4.2 Bug-report

1.4.2 Bug-report

From
Andreas Jonsson
Date:
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!



Re: 1.4.2 Bug-report

From
Andreas Pflug
Date:
Andreas Jonsson wrote:
> 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.

This is a known restriction of pg_backup; it will backup *all* pc_752.

Regards,
Andreas