Re: ERROR: table row type and query-specified row type do not match

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: ERROR: table row type and query-specified row type do not match
Дата
Msg-id b42b73150903110552x3d7bb8b5x3629c905208b1b53@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: table row type and query-specified row type do not match  (Joseph S <jks@selectacast.net>)
Список pgsql-general
On Wed, Mar 11, 2009 at 12:11 AM, Joseph S <jks@selectacast.net> wrote:
> After adding a date column to a table, I started getting these errors from
> my triggers:
>
> ERROR:  table row type and query-specified row type do not match
> DETAIL:  Query has too few columns.
>
> The triggers just did simple UPDATEs on table2 when table1 was
> updated/inserted
>
> A db restart solved the problem.  I've never seen this before.  Does anyone
> know what could have caused this?  I'm running 8.2.12

did you alter the table?  depending on how the trigger is written,
there are cases where this can be an issue.  Re-planning the trigger
function (create or replace the function source) would have been
sufficient to suppress the error.  8.3 mostly fixes this problem btw.

merlin

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: upgrade from 7.4 to 8.3
Следующее
От: George Oakman
Дата:
Сообщение: Re: C++ User-defined functions