RI violation msg suggestion

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: pghackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RI violation msg suggestion
Date: 2000-12-05 20:24:24
Message-ID: 3A2D4EF8.437FE7F4@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Minor usability/debuggability suggestion...

RI violation error messages in 7.0.0 do not appear to identify the
offending value.

Example:

ERROR: fk_employee_currency referential integrity violation - key
referenced from employee not found in currency

Easier to debug would be:

ERROR: fk_employee_currency referential integrity violation - key '27'
referenced from employee not found in currency

Regards,
Ed Loehr

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2000-12-05 20:25:52 Re: beta testing version
Previous Message Martin A. Marques 2000-12-05 20:21:38 Re: beta testing version