On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <sclark(at)netwolves(dot)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