Re: MERGE: performance advices - Mailing list pgsql-general

From Richard Broersma
Subject Re: MERGE: performance advices
Date
Msg-id 396486430809020952h3f417f9bp9a53a251bcb596f1@mail.gmail.com
Whole thread Raw
In response to Re: MERGE: performance advices  (Steve Clark <sclark@netwolves.com>)
Responses Re: MERGE: performance advices
List pgsql-general
On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <sclark@netwolves.com> wrote:
> srm2=# explain
> srm2-# INSERT INTO Myevents
> srm2-#      SELECT *

> ERROR:  INSERT has more expressions than target columns

> srm2=# explain
> srm2-# INSERT INTO Myevents
> srm2-#      SELECT *
> ERROR:  INSERT has more expressions than target columns

Oops, replace SELECT * with SELECT A.*.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: Steve Clark
Date:
Subject: Re: MERGE: performance advices
Next
From: Steve Clark
Date:
Subject: Re: MERGE: performance advices