duplicate field names in inherited table view

Bug #815882 reported by nehxby
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
pgadmin3 (Ubuntu)
New
Undecided
Unassigned

Bug Description

pgadmin v > 1.10.5
For tables with inheritance.
In sql pane and edit table dialog field names duplicates and inherited tables are specified incorrectly

Revision history for this message
nehxby (nehxby-gmail) wrote :

I try to install pgadmin vv. 1.12.2, 1.12.3 and 1.14.0beta1. Bug is present everywhere...

Postgresql v8.4

Revision history for this message
Guillaume Lelarge (guillaume-lelarge-info) wrote :

Can you be little bit more descriptive? actual schema, what pgAdmin displays, what should be displayed. Thanks.

Revision history for this message
nehxby (nehxby-gmail) wrote :

Table ad.adsell_data are inherited from some other tables (~10). I add two screenshots - for v.1.12.2 and v.1.10.5 in next comment

Revision history for this message
nehxby (nehxby-gmail) wrote :

In previous version 1.10.5 display incorrectrly only "inherited from" param, but this did not stop work

Revision history for this message
Guillaume Lelarge (guillaume-lelarge-info) wrote :

I tried today with a simple schema:

CREATE TABLE t1 (
    c1 integer NOT NULL,
    c2 text
);
CREATE TABLE t2 (
    c3 boolean
)
INHERITS (t1);
CREATE TABLE t3 (
    c1t3 bigint,
    c2t3 boolean
);
CREATE TABLE t4 (
    c5 character varying
)
INHERITS (t1, t3);

Mono inheritance (t2) and multi inheritance (t4), as you can see. Works great on 1.14, the next stable release.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.