0
Fixed

Postgresql script ignores schema when generating index

Raymond Roelands 9 year бұрын updated by anonymous 9 year бұрын 3
When generating tables and indexes the schema of the index is not generated.

Example:
CREATE TABLE myschema.mytable ( id bigserial NOT NULL, name char(64) NULL, CONSTRAINT  );
CREATE INDEX ix_mytable_01 on mytable (name ASC);  ### schema is missing here

Answer

Answer
Fixed
The issue has been fixed and deployed on production.