Richard Broersma wrote:
On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <sclark@xxxxxxxxxxxxx> 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.*.
Richard,
This is AWESOME! This now only takes seconds where before it was taking longer than
I wanted to wait, I had let it run all night before aborting it.
Thanks so much Richard,
Regards,
Steve