| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | ohp(at)pyrenet(dot)fr |
| Cc: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: should I worry? |
| Date: | 2007-11-04 17:05:15 |
| Message-ID: | 14871.1194195915@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
ohp(at)pyrenet(dot)fr writes:
> I've tried it and got those logs:
BTW, is that a complete list of the NOTICEs you got? I'd expect to see
exactly two "ignoring" messages for each "converting" message, and it's
a bit worrisome that that's not what you seem to have.
Another thing that's strange is that some of the messages reference
auto-generated trigger names instead of constraint names:
Nov 4 16:02:26 sun postgres[12505]: [227-1] NOTICE: ignoring incomplete foreign-key trigger group for constraint "RI_ConstraintTrigger_28974035" on table
Nov 4 16:02:26 sun postgres[12505]: [227-2] "perso_competences"
That's fairly unhelpful since it makes it harder to match up the
messages, but I didn't see any such cases when I was testing the patch
here.
Would it be possible for you to send me (off-list) all of the CREATE
CONSTRAINT TRIGGER commands appearing in the dump? I don't need to
see anything else, but I'm curious to look at those.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2007-11-04 17:10:09 | Re: type money causes unrestorable dump |
| Previous Message | Tom Lane | 2007-11-04 16:47:47 | Re: should I worry? |