| From: | "FarjadFarid\(ChkNet\)" <farjad(dot)farid(at)checknetworks(dot)com> |
|---|---|
| To: | "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Multiple insert |
| Date: | 2015-09-19 18:31:53 |
| Message-ID: | 000301d0f309$75056f10$5f104d30$@checknetworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am getting errors trying to insert multiple records in single statement in
table like this
CREATE TABLE "Lookup"."CNEnum1"
(
"Id" integer NOT NULL,
"Description" character varying(50),
CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY KEY ("Id")
)
WITH (
OIDS=FALSE
);
INSERT INTO "Lookup"." CNEnum1"(" Id
","Description")VALUES((1::integer,'Desc1'::varchar)
,(2::ineger,''Desc2'::varchar))
I have tried various versions of sql statement. With field casting and
without casting. Both work when a single record is inserted but with
multiple records the same error is reported.
ERROR: column "Id" is of type integer but expression is of type record
LINE 1: ... CNEnum1"("Id","Description")VALUES((1::int,'D...
^
HINT: You will need to rewrite or cast the expression.
********** Error **********
ERROR: column "Id" is of type integer but expression is of type record
SQL state: 42804
Hint: You will need to rewrite or cast the expression.
Character: 73
Any suggestion would be greatly welcomed! And thank you in advance.
Kind Regards
Farjad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Keener | 2015-09-19 18:39:25 | Re: Multiple insert |
| Previous Message | Ramesh T | 2015-09-19 08:36:48 | postgres 9.3 |