Re: Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue - Mailing list pgsql-general

If I drop the FINANCIAL_INSTIT table, create it again, and run the insert commands, it now contains 9 rows as expected.


----- Mail original -----
De: phiroc@free.fr
À: pgsql-general@postgresql.org
Envoyé: Vendredi 4 Septembre 2015 09:45:36
Objet: [GENERAL] Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue


Hello,

I am using PGSQL 9.4 for Windows on Windows 7.

when I insert 9 rows in a table called FINANCIAL_INSTIT, 24 rows end up being created!

Furthermore, accented characters encoded in UTF-8 in the original SQL file, such as
é, end up as "é".

Any help would be much appreciated.

Philippe




---------------

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Crédit Mutuel Arkea', 'CMBRFR2BPBS', 1);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'LCL Banque Privée', 'LCLPFRP1', 2);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME",  "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'BNP Paribas', 'BNPAFRPH', 3);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Abn Amro Bank N V Uk Branch', 'FTSBGB2L', 4);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Aig Investments Europe Limited', 'AIGOGB21', 5);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Abn Amro Mezzanine (Uk) Limited', 'ABAZGB21', 6);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Bank of America N A', 'FTSBGB2L', 7);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Amerasia Bank', 'AIABUS31', 8);

insert into "FINANCIAL_INSTIT" ("FINANCIAL_INSTIT_ID", "NAME", "BANK_ID_CODE", "ADDRESS_ID")
values(DEFAULT, 'Falcon International Bank', 'FAIOUS41', 9);

---------------

-- Table: "FINANCIAL_INSTIT"

-- DROP TABLE "FINANCIAL_INSTIT";

CREATE TABLE "FINANCIAL_INSTIT"
(
    "FINANCIAL_INSTIT_ID" serial NOT NULL,
  "NAME" character varying(40),
  "BANK_ID_CODE" character varying(34),
  "ADDRESS_ID" integer,
  CONSTRAINT "FINANCIAL_INSTIT_pkey" PRIMARY KEY ("FINANCIAL_INSTIT_ID"),
  CONSTRAINT "FINANCIAL_INSTIT_ADDRESS_ID_fkey" FOREIGN KEY ("ADDRESS_ID")
      REFERENCES "ADDRESS" ("ADDRESS_ID") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "FINANCIAL_INSTIT"
  OWNER TO postgres;
COMMENT ON TABLE "FINANCIAL_INSTIT"
  IS 'Financial Institution';
COMMENT ON COLUMN "FINANCIAL_INSTIT"."BANK_ID_CODE" IS 'Bank Identification Code (BIC) = SWIFT Code';

----------------------------------


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general