Обсуждение: Observed an issue while creating new table
Hi,
I have observed an issue while creating new table with pgAdmin3 which I suspect is wrong,
Steps to reproduce:
Step-1) Open new table dialog
- Enter Name: test
- Click on Inheritance tab
provide 2 table to inherit from
test1 [has columns: a,b]
test2 [has columns: x,y,z]
Click on Ok to create table.
Step-2) Now expand newly created table and click on columns and also expand it
Now click on each columns e.g.(a,b,x,y,z)
and check properties window for Inherited property, there you will see that each column will display as Inherited: Yes (from table test1)
e.g.
a ==> Inherited: Yes (from table test1)
b ==> Inherited: Yes (from table test1)
x ==> Inherited: Yes (from table test1)
y ==> Inherited: Yes (from table test1)
z ==> Inherited: Yes (from table test1)
Expected behaviour
a ==> Inherited: Yes (from table test1)
b ==> Inherited: Yes (from table test1)
x ==> Inherited: Yes (from table test2)
y ==> Inherited: Yes (from table test2)
z ==> Inherited: Yes (from table test2)
PFA screenshot for your reference.
Regards,
Murtuza
Вложения
+++
Hi,
I am using pgAdmin3 (v. 1.20)
Regards,
Murtuza
On 18-Feb-2016, at 1:38 pm, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:Hi,I have observed an issue while creating new table with pgAdmin3 which I suspect is wrong,Steps to reproduce:Step-1) Open new table dialog- Enter Name: test- Click on Inheritance tabprovide 2 table to inherit fromtest1 [has columns: a,b]test2 [has columns: x,y,z]Click on Ok to create table.Step-2) Now expand newly created table and click on columns and also expand itNow click on each columns e.g.(a,b,x,y,z)and check properties window for Inherited property, there you will see that each column will display as Inherited: Yes (from table test1)e.g.a ==> Inherited: Yes (from table test1)b ==> Inherited: Yes (from table test1)x ==> Inherited: Yes (from table test1)y ==> Inherited: Yes (from table test1)z ==> Inherited: Yes (from table test1)Expected behavioura ==> Inherited: Yes (from table test1)b ==> Inherited: Yes (from table test1)x ==> Inherited: Yes (from table test2)y ==> Inherited: Yes (from table test2)z ==> Inherited: Yes (from table test2)PFA screenshot for your reference.Regards,Murtuza<Screenshot at 2016-02-18 13:01:00.png><Screenshot at 2016-02-18 13:02:36.png>
On Thu, Feb 18, 2016 at 2:47 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
+++Hi,I am using pgAdmin3 (v. 1.20)
As discussed (personally), we resolved that problem with latest version (version: 1.22).
Regards,MurtuzaOn 18-Feb-2016, at 1:38 pm, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:<Screenshot at 2016-02-18 13:01:00.png><Screenshot at 2016-02-18 13:02:36.png>Hi,I have observed an issue while creating new table with pgAdmin3 which I suspect is wrong,Steps to reproduce:Step-1) Open new table dialog- Enter Name: test- Click on Inheritance tabprovide 2 table to inherit fromtest1 [has columns: a,b]test2 [has columns: x,y,z]Click on Ok to create table.Step-2) Now expand newly created table and click on columns and also expand itNow click on each columns e.g.(a,b,x,y,z)and check properties window for Inherited property, there you will see that each column will display as Inherited: Yes (from table test1)e.g.a ==> Inherited: Yes (from table test1)b ==> Inherited: Yes (from table test1)x ==> Inherited: Yes (from table test1)y ==> Inherited: Yes (from table test1)z ==> Inherited: Yes (from table test1)Expected behavioura ==> Inherited: Yes (from table test1)b ==> Inherited: Yes (from table test1)x ==> Inherited: Yes (from table test2)y ==> Inherited: Yes (from table test2)z ==> Inherited: Yes (from table test2)PFA screenshot for your reference.Regards,Murtuza