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@xxxxxxx
À: pgsql-general@xxxxxxxxxxxxxx
Envoyé: Vendredi 4 Septembre 2015 09:45:36
Objet: 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
