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

Поиск
Список
Период
Сортировка
От josep porres
Тема Re: pgplsql, how to save row variable to a table row
Дата
Msg-id d2d532610803260559m5d4224fawbc532c2b840a5cd0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgplsql, how to save row variable to a table row  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: pgplsql, how to save row variable to a table row  (John DeSoi <desoi@pgedit.com>)
Список 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 по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: select any table
Следующее
От: Justin
Дата:
Сообщение: Re: Make MS Access "UPDATE" PostGre SQL Table