#12217: For Greenplum DB, Add option to gui for foreign key constraint.

chandradipjain(*) reported 2014-05-29T13:07:27Z · last modified 2014-06-06T19:22:41Z

Dev	SachinPrakash
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - General
Version	Future - .9

Aqua Data Studio 15.0.0-dev-297

Build #: 38134

Built on: 2014-May-27 06:02:44 PM

OS Environment: Windows 8(x64 bit)

DB : Greenplum 4.2

Steps to reproduce :

1. Connect Greenplum db server

2. Select any database --> Go to any schema

3. Select and right click on Tables folder --> Select Create Table option

4. Create Table window opened, switch to constraints tab

5. Here in Type dropdown list Foreign option is missing.

Greenplum allows foreign key constraints.

when we try to create it through scripting in query analyzer window foreign key is created.

Alter table test.employee

add FOREIGN KEY("dept_id")

REFERENCES test.department ("dept_id")

Please see attached screenshot.

All Comments (0) Change History