postgree constraint, comment, primary and foreign keys not visible in HeidiSQL

fleduc's profile image fleduc posted 7 years ago in General Permalink

Hi. In pgAdminIII I see this on res_country_state table create code


-- Table: res_country_state

-- DROP TABLE res_country_state;

CREATE TABLE res_country_state
(
  id serial NOT NULL,
  create_uid integer, -- Created by
  code character varying(3) NOT NULL, -- State Code
  create_date timestamp without time zone, -- Created on
  name character varying NOT NULL, -- State Name
  country_id integer NOT NULL, -- Country
  write_uid integer, -- Last Updated by
  write_date timestamp without time zone, -- Last Updated on
  CONSTRAINT res_country_state_pkey PRIMARY KEY (id),
  CONSTRAINT res_country_state_country_id_fkey FOREIGN KEY (country_id)
      REFERENCES res_country (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT res_country_state_create_uid_fkey FOREIGN KEY (create_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT res_country_state_write_uid_fkey FOREIGN KEY (write_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL
)
WITH (
  OIDS=FALSE
);
ALTER TABLE res_country_state
  OWNER TO postgres;
COMMENT ON TABLE res_country_state
  IS 'Country state';
COMMENT ON COLUMN res_country_state.create_uid IS 'Created by';
COMMENT ON COLUMN res_country_state.code IS 'State Code';
COMMENT ON COLUMN res_country_state.create_date IS 'Created on';
COMMENT ON COLUMN res_country_state.name IS 'State Name';
COMMENT ON COLUMN res_country_state.country_id IS 'Country';
COMMENT ON COLUMN res_country_state.write_uid IS 'Last Updated by';
COMMENT ON COLUMN res_country_state.write_date IS 'Last Updated on';

On Heidi I see this create code tab:


CREATE TABLE "res_partner_title" (
    "id" INTEGER NOT NULL DEFAULT E'',
    "create_uid" INTEGER NULL DEFAULT NULL,
    "domain" VARCHAR NOT NULL,
    "create_date" TIMESTAMP NULL,
    "name" VARCHAR NOT NULL,
    "shortcut" VARCHAR NULL DEFAULT NULL,
    "write_uid" INTEGER NULL DEFAULT NULL,
    "write_date" TIMESTAMP NULL,
    "name_fr" VARCHAR NOT NULL,
    "shortcut_fr" VARCHAR NULL DEFAULT NULL
)
;
COMMENT ON COLUMN "res_partner_title"."id" IS E'';
COMMENT ON COLUMN "res_partner_title"."create_uid" IS E'';
COMMENT ON COLUMN "res_partner_title"."domain" IS E'';
COMMENT ON COLUMN "res_partner_title"."create_date" IS E'';
COMMENT ON COLUMN "res_partner_title"."name" IS E'';
COMMENT ON COLUMN "res_partner_title"."shortcut" IS E'';
COMMENT ON COLUMN "res_partner_title"."write_uid" IS E'';
COMMENT ON COLUMN "res_partner_title"."write_date" IS E'';
COMMENT ON COLUMN "res_partner_title"."name_fr" IS E'';
COMMENT ON COLUMN "res_partner_title"."shortcut_fr" IS E'';

Nowhere I can find the primary key, constraints nor the comments. Does these features are planned to be added shortly in Heidi?

Thanks

Please login to leave a reply, or register at first.