#11305: postgreSQL -> In ER-Modeler json datatype is not added

nisha.gaikwad(*) reported 2014-01-08T13:48:48Z · last modified 2014-12-11T20:35:59Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	16.0

ADS Version - Aqua Data Studio 15.0.0-dev-66

Operating Environment: Windows7 64-bit

Database - PostgreSQL 9.2

Go to ER-Modeler menu of ADS

Select New option

In New Entity Relationship Diagram window select PostgreSQL from database type pane and select 9.2 version from version pane

Click on OK

ER-Diagram window get open with blank sheet

Drag Table from palette to Sheet

Table_1 added to sheet

Right click on Table_1 and Select Properties

Table Properties Window open

json datatype is not added in datatype list of ER-Modeler which present in Create Table GUI

Please refer screenshot which I have attached

All Comments (3) Change History

nisha.gaikwad(*) 2014-01-17T10:16:43Z

timestamptz,tsquery,tsvector,txid_snapshot datatypes is not added in datatype list of ER-Modeler which present in Create Table GUI

Please refer screenshot which I have attached

ivangron 2014-12-09T00:09:09Z

This was resolved yesterday and code was checked in. I most have not resolved the issue in aquaclusters.

the following types have been added to erm postgres according to the correctly supporting versions.

JSON, TIMESTAMPTZ, TSQUERY, TSVECTOR, TXID_SNAPSHOT

tariqrahiman 2014-12-11T20:35:59Z

Verified in ADS v16.0.0-dev-70