On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to