Re: pgplsql, how to save row variable to a table row - Mailing list pgsql-general

From josep porres
Subject Re: pgplsql, how to save row variable to a table row
Date
Msg-id d2d532610803260559m5d4224fawbc532c2b840a5cd0@mail.gmail.com
Whole thread Raw
In response to Re: pgplsql, how to save row variable to a table row  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: pgplsql, how to save row variable to a table row  (John DeSoi <desoi@pgedit.com>)
List pgsql-general


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!!!

Thanks a lot guys!


Josep Porres

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: select any table
Next
From: Justin
Date:
Subject: Re: Make MS Access "UPDATE" PostGre SQL Table