On Mar 26, 2008, at 8:59 AM, josep porres wrote:
INSERT INTO demo_tab SELECT demo_tab_row.*;
I tried this before with no success.
But I realized that it was because a problem with a constraint, no
warnings about this at all.
With the detailed insert i've got the constraint error.
I was using the execute because I had a variable called the same as
a field, not good, I changed it.
So now it's working perfectly!!!
You don't need SELECT at all:
INSERT INTO demo_tab VALUES (demo_tab_row.*);
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
