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

Поиск
Список
Период
Сортировка
От Joseph S
Тема ERROR: table row type and query-specified row type do not match
Дата
Msg-id gp7dlr$18rp$1@news.hub.org
обсуждение исходный текст
Ответы Re: ERROR: table row type and query-specified row type do not match  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
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

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

Предыдущее
От: Glen Parker
Дата:
Сообщение: I don't want to back up index files
Следующее
От: John Wang
Дата:
Сообщение: Combine psql command with shell script