Re: pgplsql, how to save row variable to a table row

From: "josep porres" <jmporres(at)gmail(dot)com>
To: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>
Cc: rod(at)iol(dot)ie, pgsql-general(at)postgresql(dot)org
Subject: Re: pgplsql, how to save row variable to a table row
Date: 2008-03-26 12:59:15
Message-ID: d2d532610803260559m5d4224fawbc532c2b840a5cd0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-03-26 13:11:36 Re: RULES and QUALIFICATION for INSERT
Previous Message Sam Mason 2008-03-26 12:56:11 Re: select any table