Aqua Data Studio: 19.0.0-beta-31
Build #: 55374
Build Date: 2017-Aug-02 04:45:30 PM
Operating Environment: Linux (4.4.0-87-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072; Total=324,534,272; Free=160,995,984; CPUs=8
Steps:-
Connect PostgreSQL
CREATE TABLE products (
product_no integer PRIMARY KEY,
name text,
price numeric
)
GO
CREATE TABLE "public"."orders" (
"order_id" integer NOT NULL,
"product_no" integer NULL,
"quantity" integer NULL,
PRIMARY KEY("order_id")
)
WITHOUT OIDS
TABLESPACE "pg_default"
GO
ALTER TABLE "public"."orders"
ADD CONSTRAINT "orders_product_no_fkey"
FOREIGN KEY("product_no")
REFERENCES "public"."products"("product_no")
MATCH SIMPLE
ON DELETE NO ACTION
ON UPDATE NO ACTION
GO
COMMENT ON CONSTRAINT "orders_product_no_fkey" ON "public"."orders" IS 'This is comment on Check Constraint'
GO
COMMENT ON CONSTRAINT "orders_pkey" ON "public"."orders" IS 'This is comment on Check Constraint'
GO
Steps-01:
Go to table tree node
Right click on orders and select alter table option
Alter table window opens
Switch to constraint tab
Select Primary key or foreign key.
Go to constraint detail Pane
Actual result:
You can see that, Primary key comment or foreign key comment option is disabled.
Expected Result:
Primary key comment or foreign key comment option should be enabled.
Observation:
I have executed below script and go to Alter table->Constraint tab
=>You can see that constraint comment is updated successfully.
COMMENT ON CONSTRAINT "orders_product_no_fkey" ON "public"."orders" IS 'This is comment on Check Constraint update'
GO
COMMENT ON CONSTRAINT "orders_pkey" ON "public"."orders" IS 'This is comment on Check Constraint update'
GO
|
Database |
|
PostgreSQL-9.6/9.5/9.4/9.3/9.2/9.1/9.0 |
|
|
Windows |
Ubuntu |
|
ADS19.0-beta31 |
Y |
Y |
|
Introduce version(comment support to the constraint) ADS 19-alpha-25 |
Y |
Y |
Y - Yes, issue reproduced.
|
