| 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 16:47:47 |
| Message-ID: | 14625.1194194867@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
ohp(at)pyrenet(dot)fr writes:
> I've got two problems:
> Looking at the errors, ISTM foreign statement is the over way round :
> levt_tevt_cod is in ligne_evt NOT in type_evt
No, that's just how we've worded FK violation errors for some time.
The real question is how did FK violations get into your dump?
> And, looking at the generated foreign keys, I don't see ON UPDATE/ON
> DELETE clauses
The ones we can see here are default (NO ACTION) cases, so I'm not
convinced you're describing a real problem.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-04 17:05:15 | Re: should I worry? |
| Previous Message | ohp | 2007-11-04 16:26:02 | Re: should I worry? |