Try dropping the word "VALUES".
eg.
INSERT INTO "tblSpecs" ("CartridgeTypeID", "ColorID",
"TestTypeID","ZoneID", "PaperID", "AttributeID", "Spec")
SELECT "CartridgeTypeID", "ColorID", "TestTypeID","ZoneID", "PaperID",
"AttributeID","Spec" from "tblTempSpecs";
On Thu, Jul 16, 2009 at 12:40 PM, Relyea, Mike<Mike.Relyea@xxxxxxxxx> wrote:
> I need help understanding what I'm doing wrong with an insert statement.
> I'm running 8.3.7 on Windows and the DB is complaining about the select
> statement in my insert statement.
>
> I'm trying to execute
>
> DROP TABLE IF EXISTS "tblTempSpecs";
> CREATE TEMP TABLE "tblTempSpecs" AS SELECT "tblSpecs"."CartridgeTypeID",
> "tblSpecs"."ColorID", "tblTestTypes"."TestTypeID", "tblZones"."ZoneID",
> "tblSpecs"."PaperID",
> "tblSpecs"."AttributeID", "tblSpecs"."Spec"
> FROM "tblSpecs", "tblZones", "tblTestTypes"
> WHERE "tblSpecs"."ZoneID" IS NULL AND "tblTestTypes"."TestTypeID" IN
> (SELECT DISTINCT "TestTypeID" FROM "tblCartridgePQSetIntervals" WHERE
> "CartridgeTypeID" = 74);
>
> INSERT INTO "tblSpecs" ("CartridgeTypeID", "ColorID", "TestTypeID",
> "ZoneID", "PaperID", "AttributeID", "Spec") VALUES SELECT * FROM
> "tblTempSpecs";
>
> To insert data into
>
> CREATE TABLE "tblSpecs"
> (
> "SpecID" integer NOT NULL DEFAULT
> nextval('"sequence_SpecID"'::regclass),
> "CartridgeTypeID" integer NOT NULL,
> "ColorID" integer NOT NULL,
> "TestTypeID" integer,
> "ZoneID" integer,
> "PaperID" integer,
> "PrintCopyID" integer,
> "AttributeID" integer NOT NULL,
> "Spec" numeric NOT NULL,
> CONSTRAINT "tblSpecs_pkey" PRIMARY KEY ("SpecID"),
> CONSTRAINT "tblSpecs_AttributeID_fkey" FOREIGN KEY ("AttributeID")
> REFERENCES "tblAttributes" ("AttributeID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT "tblSpecs_CartridgeTypeID_fkey" FOREIGN KEY
> ("CartridgeTypeID")
> REFERENCES "tblCartridgeTypes" ("CartridgeTypeID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT "tblSpecs_ColorID_fkey" FOREIGN KEY ("ColorID")
> REFERENCES "tblColors" ("ColorID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT "tblSpecs_PaperID_fkey" FOREIGN KEY ("PaperID")
> REFERENCES "tblPaperTypes" ("PaperID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT "tblSpecs_TestTypeID_fkey" FOREIGN KEY ("TestTypeID")
> REFERENCES "tblTestTypes" ("TestTypeID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION,
> CONSTRAINT "tblSpecs_ZoneID_fkey" FOREIGN KEY ("ZoneID")
> REFERENCES "tblZones" ("ZoneID") MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION
> )
> WITH (
> OIDS=FALSE
> );
>
> What am I doing wrong?
>
> Mike
>
>
> --
> 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
