Postgres Pro
Downloads
Home   >   mailing lists

ERROR: table row type and query-specified row type do not match - Mailing list pgsql-general

From Joseph S
Subject ERROR: table row type and query-specified row type do not match
Date
Msg-id gp7dlr$18rp$1@news.hub.org
Whole thread Raw
Responses Re: ERROR: table row type and query-specified row type do not match  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Glen Parker
Date:
Subject: I don't want to back up index files
Next
From: John Wang
Date:
Subject: Combine psql command with shell script