Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue

From: phiroc(at)free(dot)fr
To: pgsql-general(at)postgresql(dot)org
Subject: Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue
Date: 2015-09-04 07:45:36
Message-ID: 1733103452.89307987.1441352735998.JavaMail.root@zimbra65-e11.priv.proxad.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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';

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message phiroc 2015-09-04 07:51:50 Re: Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue
Previous Message Craig Ringer 2015-09-04 03:36:40 Re: bdr admin role