Thread: Bug CREATE Script
Version
4.5
Copyright
Copyright (C) 2013 - 2019, The pgAdmin Development Team
Python Version
3.7.2 (tags/v3.7.2:9a3ffc0492, Dec 23 2018, 22:20:52) [MSC v.1916 32 bit (Intel)]
Flask Version
1.0.2
Application Mode
Desktop
Microsoft Windows [versão 10.0.17763.437]
Object -> Scripts -> CREATE Script
Create Script is not working right, some fields repeat
worked fine until version 4.3
worked fine until version 4.3
-- Table: financa.caixa3_moviment
-- DROP TABLE financa.caixa3_moviment;
CREATE TABLE financa.caixa3_moviment
(
data date,
data date,
data date,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
natureza character varying(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
...
-- DROP TABLE financa.caixa3_moviment;
CREATE TABLE financa.caixa3_moviment
(
data date,
data date,
data date,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
natureza character varying(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
...
...
Hi Mario
We have fixed this issue in v4.6. Please upgrade to the latest version 4.6
On Thu, Apr 18, 2019 at 10:42 PM Mario Simoes Filho <msimoes.filho@gmail.com> wrote:
Version4.5CopyrightCopyright (C) 2013 - 2019, The pgAdmin Development TeamPython Version3.7.2 (tags/v3.7.2:9a3ffc0492, Dec 23 2018, 22:20:52) [MSC v.1916 32 bit (Intel)]Flask Version1.0.2Application ModeDesktopMicrosoft Windows [versão 10.0.17763.437]Object -> Scripts -> CREATE ScriptCreate Script is not working right, some fields repeat
worked fine until version 4.3-- Table: financa.caixa3_moviment
-- DROP TABLE financa.caixa3_moviment;
CREATE TABLE financa.caixa3_moviment
(
data date,
data date,
data date,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
elemento character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
natureza character varying(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
escrevente character(4) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
......
Thanks & Regards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
Mobile: +91 976-788-8246