#14917: Datatype tree also shows table objects list.

pallavpoddar reported 2017-01-11T13:03:49Z · Bhavana(*) last modified 2017-07-25T13:26:06Z

Datatype tree also shows table objects list.

Dev	JennyNishimura
QA	ivangron

Priority	Minor
Complexity	Unknown

Component	DB - PostgreSQL
Version	19.0

Product: Aqua Data Studio

Version: 18.0.0-preview-2

Build #: 52626

Build Date: 2017-Jan-09 05:45:32 PM

Operating Environment: Linux (4.4.0-57-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=204,996,608; Free=81,299,208; CPUs=8

To reproduce this issue execute below script:

CREATE DATABASE "FY_4"
   WITH TEMPLATE = template0
   TABLESPACE = pg_default
GO

USE "FY_4"
GO

create table a1(
    clm_1 varchar
)

now navigate to the datatype object in object tree window.

The Same behaviour is observed in v17.

ADS Version	Operating System			Postgres SQL Version
	Windows	Linux	OSX	v8.3	v9.4	v9.5	v9.6
v18	Y	Y	Y	Y	Y	Y	Y
v17	Y	Y	Y	Y	Y	Y	Y
v16	Y	Y	Y	Y	Y	Y	Y
v15	Y	Y	Y	Y	Y	Y	Y

Is this expected behaviour?

Please refer the attachment.

2 attachments

postgres_datatype.png

2017-01-11T13:03:49Z

345 KB
Updated_14917.png

2017-06-05T12:52:11Z

135 KB

All Comments (7) Change History

SachinPrakash 2017-01-11T15:59:19Z

Pls provide complete regression matrix.

Work w/ @abhishek if you have any questions.

pallavpoddar 2017-01-12T13:46:57Z

@Sachin Sir,

Pls provide complete regression matrix.

Work w/ @abhishek if you have any questions.

I have Added the regression matrix in this issue.
Please let me know if anything else is required.

SachinPrakash 2017-03-18T13:50:40Z

What does PGAdmin show?

pallavpoddar 2017-03-20T04:49:14Z

@sachin sir,

PgAdmin shows the details Correctly. I have mentioned that in the Attachment.

JennyNishimura 2017-06-02T00:39:44Z

This is resolved by issue #15179.

In v19, we support the following nodes:

- Domains node lists all the objects that are created using CREATE DOMAIN.
- Datatypes node lists all the objects that are created using CREATE TYPE.

raghavsingh 2017-06-05T12:52:01Z

Verified in ADS-19.0.0-alpha27. Refer updated screenshot 'updated_14917.png'

Bhavana(*) 2017-07-25T09:04:52Z

Re-verified in Aqua Data Studio 19.0.0-beta-21.

Search Tips

Aqua Data Studio / nhilam

Datatype tree also shows table objects list.

2 attachments

Issue #14917

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Datatype tree also shows table objects list.

2 attachments

Issue #14917

Completion