× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nishtha(*) reported 2015-03-30T12:24:08Z  · kirtipbankar(*) last modified 2017-07-27T10:11:48Z

PostgreSQL 9.3 : Default Value is not displayed in 'Table Properties' window for some datatypes.


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component DB - PostgreSQL
Version 19.0

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.

2 attachments

Issue #13192

Closed
Fixed
Resolved 2017-07-26T18:29:26Z
 
 
Completion
No due date
Fixed Build ADS 19.0.0-beta-23
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017