Richard Broersma wrote:
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.*.
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
