Richard Broersma wrote:
> 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.*.
>
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