| Lists: | pgsql-general |
|---|
| 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 |
| 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
| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Joseph S <jks(at)selectacast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: table row type and query-specified row type do not match |
| Date: | 2009-03-11 12:52:20 |
| Message-ID: | b42b73150903110552x3d7bb8b5x3629c905208b1b53@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Wed, Mar 11, 2009 at 12:11 AM, Joseph S <jks(at)selectacast(dot)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