Product: Aqua Data Studio
Version: 16.0.1-9
Build #: 43154
Build Date: 2015-Mar-25 07:04:16 PM
Operating Environment: Linux (3.13.0-32-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=268,435,456; Free=69,653,552; CPUs=8
Steps to reproduce issue:
1. Connect to PostgreSQL9.3.
2. Create a Table with json, tsquery, tsvector and txid_snapshot datatypes with Default values:
CREATE TABLE "test"."Datatypes_defaultValue" (
"col_bigint" int8 NOT NULL DEFAULT 1,
"col_json" json NOT NULL DEFAULT '{"k1":1,"k2":"two"}',
"col_tsquery" tsquery NOT NULL DEFAULT 'rmubezzPTdKB',
"col_tsvector" tsvector NOT NULL DEFAULT 'NYdpRg',
"col_txid_snapshot" txid_snapshot NOT NULL DEFAULT '10:20:10,14,15'
)
GO
3. Now run Insert query as :
INSERT INTO "test"."Datatypes_defaultValue"("col_bigint")
VALUES(1)
GO
4. Run SELECT * query on created table-> default values are inserted in it successfully. :
SELECT * FROM "test"."Datatypes_defaultValue"
GO
5. Now go to Tables tree node -> Right click on created Table -> Select 'Table Properties' option.
In Table Properties window for json, tsvector, tsquery and txid_snapshot datatypes default values are not displayed.
Here default value should be displayed.
|
217 KB
|
146 KB
The reported data types were missing in AFTableColumnInitPostgreSQL.
- JSON was added in alpha-61 by issue #15350
- I've added TSQUERY, TSVECTOR, TXID_SNAPSHOT.
This issue is now resolved.
The reported data types were missing in AFTableColumnInitPostgreSQL.
- JSON was added in alpha-61 by issue #15350
- I've added TSQUERY, TSVECTOR, TXID_SNAPSHOT.
This issue is now resolved.
Closed and verified issue in ADS19.0.0-beta-24
please refer screenshot closed_13192.png
default value displayed successfully
Closed and verified issue in ADS19.0.0-beta-24
please refer screenshot closed_13192.png
default value displayed successfully
Issue #13192 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 19.0.0-beta-23 |
No time estimate |
This issue also occurs in version 15.