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

From: Joseph S <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: table row type and query-specified row type do not match
Date: 2009-03-11 04:11:38
Message-ID: gp7dlr$18rp$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Wang 2009-03-11 06:37:26 Combine psql command with shell script
Previous Message Glen Parker 2009-03-11 01:54:30 I don't want to back up index files