Creating a primary key works fine.
When attempting to creating any other type of key, fails when clicking on the Save button with the following:-
ALTER TABLE "pcd11_par11_wd11_lad11_ew_lu"
ADD INDEX "Index 2" ("pcds");
/* ERROR: type "Index 2" does not exist
LINE 2: ADD INDEX "Index 2" ("pcds")
If I create an index in pgAdmin, it does not show up in Heidi.
Creating indexes in Postgres r4811.
Yes, the primary and unique keys are analyzed with such a query in HeidiSQL:
I guess I need to extend ParseTableStructure again, to get all other keys into the table editor too.
Is that above query without the "CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE')" valid to get all keys?
SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='mytable' AND K.TABLE_SCHEMA='myschema' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION;
I guess I need to extend ParseTableStructure again, to get all other keys into the table editor too.
Is that above query without the "CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE')" valid to get all keys?
Please login to leave a reply, or register at first.