Multiple insert

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

Responses

Browse pgsql-general by date

  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